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 am trying to calculate the running total of a set of measures by months in my matrix. The running total is working by itself, however when used with my monthly slicer it breaks. I want it to calculate up to the month selected in the slicer, but instead it filters for that specific month.
example: when I select May I want to see running total froo every month from Jan to May but it shows me data only in the month of May.
Running Total = CALCULATE
( SUM ( Table[column] ),
FILTER ( ALLSELECTED( Table ),
Table[columnDate] <= MAX ( Table[ColumnDate] ) ) )
The Month Slicer comes from Table[ColumnDate].Month
Hi,
Here's my approach:
Total = SUM(Table[Column])
Total YTD = CALCULATE([Total],DATESYTD(Calendar[Date],"31/12"))
Hope this helps.
Perhaps:
Running Total = CALCULATE
( SUM ( Table[column] ),
FILTER ( ALLEXCEPT( Table[ColumnDate ),
Table[columnDate] <= MAX ( Table[ColumnDate] ) ) )
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |