Home Forums Power Pivot Cumulative calcaltions without zeros

This topic contains 0 replies, has 1 voice, and was last updated by  mfarr76 2 years, 10 months ago.

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

    mfarr76
    Participant
    • Started: 6
    • Replies: 6
    • Total: 12

    Hello,

    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?

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

    Thanks in advance!

     

    Attachments:
    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.