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.
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] )
)
)
Solved! Go to Solution.
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.
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
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.
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |