Forum Discussion
Running Total Keeps resetting
Thanks for the reply from bhanu_gautam and PBIViz_2024.
Hi SparkD ,
If you want to achieve the effect that the months beyond the current month are blank, a measure can be written for filtering.
Here is a simple example:
1.Create a table:
2.Create a measure:
Measure = IF(MAX('Table'[Month])<=MONTH(TODAY()),1,0)3.Drag the measure to the filter pane, then set the condition to 1:
4.The effect is as follows:
Best Regards,
Zhu
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Hi,
This is because you have used DATESYTD.since you have not provided 2nd parameter which is year end date.it will use 31st December as the year end and calculate the running total for the Calendar Year.If you need this for the entire fiscal Year you have to specify the Year end.
if your Fiscal year is April-March.Dax should be something like below
Running Sum = CALCULATE([Planned Count],DATESYTD('Month Ending'[Month Ending],"31/03"))
More info.
https://learn.microsoft.com/en-us/dax/datesytd-function-dax
Regards,