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
Icey's avatar
Icey
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Try this:

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

 

If this doesn't work either, please share me your .pbix file for test. Please remove sensitive information. It is suggested to upload your file to OneDrive for Business and then paste the link here.

 

 

Best regards

Icey

 

If this post helps,then consider Accepting it as the solution to help other members find it faster.