Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have a Order revenuew YTD measure, which is showing monthly values only for past months in current year and corresponding months in all previous years. DAX for this is:
Now I need to have similar measure but as cumulative version and cumulative prev year version.
I have already a cumulative YTD measure but it is showing values for all months, not only for months as defined in first measure. DAX for this measure is:
Solved! Go to Solution.
Add a filter
Month('Project - Calendar Period'[Date])<Month(TODAY())
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
32 | |
14 | |
13 | |
12 | |
9 |