Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Running Total show blank on dates

Hello all   I hope you can give me help   I would like to show running totals, but only until the last call.  So my matrix shows below, so if nothing happened on 03/01/2019 then it stays blank  ...
Need Help
nahid3152's avatar
nahid3152
Icon for Helper II rankHelper II
6 years ago

HI,Anonymous 
Use

RunningTotal = CALCULATE([SUM],FILTER(ALL(Sheet1[Date]),Sheet1[Date] <= Max(Sheet1[Date])))
Format Date  from modeling 


Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello Nahid

 

I'm using the same formula already as you suggested. Which works if I want to populate the blank dates, but I  want to show when no sales appear. So the 03/01/2019 appears as blank

 

Thanks

Joe