Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have made a measure for the cummulative total of another measure using the following DAX formula:
Cummulative:= CALCULATE([Measure],DATESYTD('Date'[Date])
This gives the following result for a visual using the 'Date'[Date] collumn as the x-axis:
But if I try with the 'Date'[Month] collumn instead, I get a simple sum for each month:
How do I get the cummulative total for each month to work the same as the date?
Solved! Go to Solution.
Hi @Anonymous ,
Try to create your Measure like so:
Cummulative 2 =
CALCULATE (
[Measure],
FILTER (
ALLSELECTED ( 'Date' ),
[Date].[Year] = YEAR ( MAX ( [Date] ) )
&& [Date] <= MAX ( [Date] )
)
)
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Try to create your Measure like so:
Cummulative 2 =
CALCULATE (
[Measure],
FILTER (
ALLSELECTED ( 'Date' ),
[Date].[Year] = YEAR ( MAX ( [Date] ) )
&& [Date] <= MAX ( [Date] )
)
)
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This solution worked straight out of the box! Thank you very much! Kudos to you.
@Anonymous
Is the Date table is marked as a date table? This should work. Right click on date table you have an option
Refer step at: https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-1-Time-Intelligence-in/ba-p/922885
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |