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.
Hi,
I have a Date table and fact table related by field called Year
I want to achieve a table like this:
Year | MonthNo | sales | Monthly Cumulative |
2022 | 01 | 20 | 20 |
2022 | 02 | 30 | 50 |
2022 | 03 | 40 | 90 |
2022 | 04 | 50 | 140 |
I have used this dax to obtain this measure Monthly cumulative:
Monthly cumulative=
calculate(sum(sales),
filter(allselected('Date'),
'Date'[Dates]<=Max('Date'[Dates])))
But the result is
140
140
140
140
I want to this in a bar graph too.
How do i do this?
Solved! Go to Solution.
Hi,
I am not sure how your datamodel looks like, but please try something like below whether it suits your requirement.
Monthly cumulative =
CALCULATE (
SUM ( sales[revenue] ),
FILTER ( ALLSELECTED ( 'Date'[Dates] ), 'Date'[Dates] <= MAX ( 'Date'[Dates] ) )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
please check your relationship of date and sale table and also filter direction of table.
Thanks guys. I got the answer when I was just posting this question. However, the reply button deactivated, when I want to say.. I got the answer.
Thanks again for looking into it.
please check your relationship of date and sale table and also filter direction of table.
Hi,
I am not sure how your datamodel looks like, but please try something like below whether it suits your requirement.
Monthly cumulative =
CALCULATE (
SUM ( sales[revenue] ),
FILTER ( ALLSELECTED ( 'Date'[Dates] ), 'Date'[Dates] <= MAX ( 'Date'[Dates] ) )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |