Handling Missing Currency Dates using Average-To-Date
Here is the 5th video in the series on handling missing currency rates. Here I will show how to use Average-To-Date to account for missing currency rate data as well as techniques to show multiple conversion methods with one measure
Hope you'll get a lot from it.
Nick Mone
**** Video Details ****
0:30 recap of the video on basic currency conversion
1:22 recap of the video on format converted measures to the appropriate currency format
2:05 recap of the video on accounting missing currency using strictly DAX
3:08 recap of the video on accounting missing currency rate using PowerQuery
4:26 things we will cover in this video
6:53 currency rate table with missing rates
11:08 monthly average rate to date measures
12:31 mark table as date table
14:36 last currency date
16:51 measure of monthly average rate if missing, actual rate if not missing
20:47 create a table using DATATABLE
24:42 selected currency rate measure
27:00 DimCurrency table using SELECTEDVALUE
30:23 rate type selected
34:53 iterating through rate type selected using SWITCHTRUE
**** Related Videos ****
Simple Currency Conversion in Power BI w/DAX - • Simple Currency Conversion in Power B...
How To Format Currencies In Power BI w/ DAX - • How To Format Currencies In Power BI ...
Accounting For Missing Currency Rates w/DAX - • Accounting For Missing Currency Rates...
Accounting For Missing Data In Currency Table w/PowerQuery - • Accounting For Missing Data In Curren...
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...
Watch video Handling Missing Currency Dates using Average-To-Date online, duration hours minute second in high quality that is uploaded to the channel Enterprise DNA 05 July 2020. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 1,077 times and liked it 15 visitors.
