Forum Discussion
Sum add all the previous elements to a date
You want a running total (cummulative total).
Check the link below how to do it,
https://whatthetechisthat.wordpress.com/2017/05/30/power-bi-cumulative-totals/
If your date field in below table is a date heirarchy, then you can choose only month and year. You need to have a calendar table and establish relatship with your data table.
Running Toal Measure =
CALCULATE(
Sum(Table[Value],
FILTER(All(Dim_Date[Date]), Dim_Date[Date] <= MAX(Dim_Date[Date]
)
)
Skilled SharerYou want a running total (cummulative total).
Check the link below how to do it,
https://whatthetechisthat.wordpress.com/2017/05/30/power-bi-cumulative-totals/
If your date field in below table is a date heirarchy, then you can choose only month and year. You need to have a calendar table and establish relatship with your data table.
Running Toal Measure =
CALCULATE(
Sum(Table[Value],
FILTER(All(Dim_Date[Date]), Dim_Date[Date] <= MAX(Dim_Date[Date]
)
)
