Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Running Total

I have a created date calculated column Total sum requirements as a measure I want to create a running total and replace the total sum requirements by running total Unfortunately, the quick measur...
Need Help
themistoklis's avatar
themistoklis
Community Champion
5 years ago

Anonymous 

 

Try any of the following 2

 

 

Total Requirements running total in Created 2 =
CALCULATE (
    [Total Requirements],
    FILTER (
        ALLSELECTED ( 'SP Fit/Gap' ),
        'SP Fit/Gap'[Created] <= MAX ( 'SP Fit/Gap'[Created] )
    )
)

-- OR 

Total Requirements running total in Created 2 =
CALCULATE (
    [Total Requirements],
    FILTER (
        ALL ( 'SP Fit/Gap' ),
        'SP Fit/Gap'[Created] <= MAX ( 'SP Fit/Gap'[Created] )
    )
)

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

After the calculation, this is how the chart looks like

 

 

  • themistoklis's avatar
    themistoklis
    Community Champion
    5 years ago

    Anonymous 

     

    Can you share the workspace with us?

    Mask any sensitive data

  • themistoklis's avatar
    themistoklis
    Community Champion
    5 years ago

    Anonymous 

     

    Also can you add the date field, the date value and running value in a table and share a snapshot with us so as to see how it looks like?