Forum Discussion
Running Total Removing Blanks
Hi,
To your visual, ensure that you drag the Date column from the Date table. Write this measure:
Current Running Total Measure =calculate([Sales],datesmtd(calendar[date]))
Hope this helps.
Hi,
Thanks alot for your help. This fills in the blanks that I was getting before and computes a new total starting every month.
I've added the date column from the date table and the calculation you posted but how do I get it to stop showing any values or show blanks past the sales date. The last sales date is the 04/05.Thanks
Hi,
Share the link from where i can download your PBI file.
For context, what I am tring to do is create the table to stop dsplaying the running total after the last sales date and have the line graph to stop displaying after the last sales date as it plateaus and becomes flat.
The requirement is that there must be a line graph that is categorical, with a running total that stops after the last sales date. And a slicer that can select different months where the running total should reset every month. I completed this using my measure (Running Total Measure) but it shows blanks and gaps in previous months where there is no sales on a date.
Using your measure worked but then it it keeps running until the end of the month and becomes flat.
Ideally I need a combination of the two, a running total that has no blanks for any date and it should stop running after the last sales date.
Any help would be appreciated.