Home Forums Power Pivot Cumulative calcaltions without zeros

This topic contains 0 replies, has 1 voice, and was last updated by  mfarr76 3 years, 1 month ago.

Viewing 1 post (of 1 total)
  • Author
  • #2685

    • Started: 6
    • Replies: 6
    • Total: 12


    I want to calculate a running cumulative total over time.  The dataset has zeros (0) in it so there is a flat spot when I plot cum vs. time.  There is a flat spot because I have the same value that is generated due to the zeros.

    I have created a calculated column that if the value = 0 then it returns blank() but when I calculate the cums with the equation below I still get a flat spot.

    What I am trying to accomplish is a cumulative column that removes the zeros and shifts up, so there isn’t a flat spot of a blank space in the cumulative curve when plotted vs time.

    The attached might clear up any confusion.

    Can someone please point me in the right direction?

    SUM ( Press_Table[Press_No zero] ),
    FILTER (
    Press_Table[Name] = EARLIER ( Press_Table[Name] )
    && Press_Table[Days] <= EARLIER ( Press_Table[Days] )

    Thanks in advance!


    You must be logged in to view attached files.
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.