Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have a problem with the time-intelligence based measure.
Its purpose is to pull the value of prior month's exchange rate from a table, which looks as follows:
Table name is 'UnpivotedBasic':
The measure to pull the prior month's rate is (not working):
Functions work separately, I mean if I enter: CALCULATE(SUM(UnpivotedBasic[Value])) it shows the value for the current month and if I type in only DATEADD('Calendar'[Date],-1,MONTH) it correctly shows the prior month but if combined the 'blank' is returned....
'Calendar'[Date] is a date table and date range is continuous therein. Accounting rates are only published monthly hence I created a separate 'Calendar'[Date] table.
Regards
Krzysztof
Solved! Go to Solution.
Thank you. I've just solved the issue. It looks the reason was that some other slicer was in conflict with this measure. Having added the 'ALL' function within Calculate helped and it's now working ! 🙂
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Thank you. I've just solved the issue. It looks the reason was that some other slicer was in conflict with this measure. Having added the 'ALL' function within Calculate helped and it's now working ! 🙂