Forum Discussion
Cumulative value error
Hai, I had created cumulative but in between, it showed wrong values
you can see if we add 202 + 18 = 220(Actual) But I am getting 214 I am confused why this is showing in this way
And the second error is the sales total is shown below and my cumulative total is shown in the top
How I can solve these two issues Please help me
And this is the dax i had used
sales Cumulative =
CALCULATE (
[sales],
DATES BETWEEN (
'Calendar'[Date],
NEXTDAY ( SAMEPERIODLASTYEAR ( LASTDATE ( 'Calendar'[Date] ) ) ),
LASTDATE ( 'Calendar'[Date] )
)
)
Hi, AlanP514
You can try the following methods.
Sales Cumulative = CALCULATE ( [Sales], FILTER ( ALL ( 'Table' ), [Year Month] <= SELECTEDVALUE ( 'Table'[Year Month] ) ) )Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Try this:
Step 1: Create Measure
Cumulative Total =
CALCULATE (
SUM ( 'Table'[Sales] ),
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] <= MAX ( 'Table'[Date] ) )
)Accept as solution if its worked.
Hi, AlanP514
You can try the following methods.
Sales Cumulative = CALCULATE ( [Sales], FILTER ( ALL ( 'Table' ), [Year Month] <= SELECTEDVALUE ( 'Table'[Year Month] ) ) )Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hai,Your solution really helped me i will accept as a solution,
can you help me to solve this requirement
https://community.powerbi.com/t5/Desktop/Converting-static-to-Dynamic-Measure/m-p/2550780
