Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you @MFelix and @TomMartens for your help. This Measure and Formula helped me.
Hey @MFelix, there is nothing to excuse for, whatever helps to answer the question - is good 👍
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
Hey,
somehow I miss the scenario you mentioned 😉
Regards
Tom
Can you see now. i have added few more information.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |