Power BI - DAX - Burndown/Up calculation

[pmuralikrishna1]

Hi,

I'm trying to calculate burndown/up data with a measure. I have the below scenario.

Expected Data for each row should be sum the previous total:

like 

So i can have a graph showing burn down/up chart. like below screenshot for reference.

 

 PBIX file: https://1drv.ms/u/s!AumHWDrVM37itl3rthHLTjj2zSaI

[MFelix · Accepted solution]

Hi @pmuralikrishna1,

Although the solution provided by my fellow datanaut @TomMartens (Tom please excuse me for responding also to this ) should be accurate I prefer to make the approach by a measure.

Make a measure with the following code:

Revenue Cumulative =
CALCULATE (
    SUM ( Revenue[Revenue] );
    FILTER ( ALL ( Revenue[Date] ); Revenue[Date] <= MAX ( Revenue[Date] ) )
)

As you can see below the expected result is achieved (green line is the column you used black is the measure)

Regards,

MFelix

[pmuralikrishna1]

Thank you @MFelix and @TomMartens for your help. This Measure and Formula helped me.

[TomMartens]

Hey @MFelix, there is nothing to excuse for, whatever helps to answer the question - is good 👍

[TomMartens]

Hey,

you can create a calculated column like so:

**bleep** Revenue by Project = 
var currentProject = 'yourTablename'[Project]
var currentDate = 'yourTablename'[Date]
return
CALCULATE(
    SUM('yourTablename'[Price])
    ,FILTER(All('yourTablename')
        ,'yourTablename'[Project] = currentProject && 'yourTablename'[Date] <= currentDate
    )
)

Hopefully this is what you are looking for

Regards Tom

[TomMartens]

Hey,

somehow I miss the scenario you mentioned 😉

Regards

Tom

[pmuralikrishna1]

Can you see now. i have added few more information.