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 a table shown Below:
I need to have a 4th line that takes a cumulative total over the months. So February shows the total for Jan and Feb, March Shows Jane Feb & March etc. I have tried the Running Total Function but it doesnt seem to do what i want.
This is the Filters i Have also:
It is taking a sharepoint list and filtering to 2022 only. The Choice field on the list is for Closed and Open NCR's. i then have a difference line between the two to show backlog.
Solved! Go to Solution.
Hi @jamescosten ,
Please try the measure.
Measure =
CALCULATE (
SUM ( 'Table'[Backlog] ) + SUM ( 'Table'[Closed] )
+ SUM ( 'Table'[Open] ),
DATESINPERIOD ( 'Calendar'[Date], MAX ( 'Calendar'[Date] ), -2, MONTH )
)
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jamescosten ,
Please try the measure.
Measure =
CALCULATE (
SUM ( 'Table'[Backlog] ) + SUM ( 'Table'[Closed] )
+ SUM ( 'Table'[Open] ),
DATESINPERIOD ( 'Calendar'[Date], MAX ( 'Calendar'[Date] ), -2, MONTH )
)
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@jamescosten , usally we have this kind of measure for running total
Cumm = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))
Cumm = CALCULATE(SUMX(Values('Date'[Month]), [Measure]) ,filter(allselected('Date'),'Date'[date] <=max('Date'[date])))
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |