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...
Смотрите видео Handling Missing Currency Dates using Average-To-Date онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Enterprise DNA 05 Июль 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,077 раз и оно понравилось 15 людям.