Forum Discussion

pmuralikrishna1's avatar
pmuralikrishna1
Frequent Visitor
8 years ago
Solved

Power BI - DAX - Burndown/Up calculation

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 g...
Tips and Tricks
  • MFelix's avatar
    MFelix
    8 years ago

    Hi pmuralikrishna1,

     

     

    Although the solution provided by my fellow datanaut TomMartens (Tom please excuse me for responding also to this :smileyhappy:) 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

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi pmuralikrishna1,

 

 

Although the solution provided by my fellow datanaut TomMartens (Tom please excuse me for responding also to this :smileyhappy:) 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's avatar
pmuralikrishna1
Frequent Visitor
8 years ago

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