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

 

Date                                  Running Total

01/01/2019                             10

02/01/2019                             25

03/01/2019                           

04/01/2019                             47

05/01/2019                             63

 

My current measure

 

Calls Completed =
CALCULATE (
    DISTINCTCOUNT( Calls[ID] ),
    FILTER (
        ALL( 'calendar'[Date]),
       'calendar'[Date] <= MAX ( 'calendar'[Date] )
       )
       )
 
Thanks
Joe
Need Help

5 Replies

  • 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I solved it by using the dates in the call's table instead of the date table

         

        thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Just Use this

    IF(logical_test>,<value_if_true>, value_if_false)

    and replace your blank with 0.

    Your Graph will render with no error.