Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
Fairly new to Power BI, so there's probably a simple solution for my problem!
I have the following table ('Burnup Data') where I am trying to calculate a running total (Planned Cumulative) based on Planned. However, the existing Planned Cumulative is not the Expected Result:
I have the following measures:
Solved! Go to Solution.
Hi @simonm8008 ,
I have created a simple sample, please refer to it to see if it helps you.
sum for a calculated column.pbix
Create a measure.
Measure =
CALCULATE (
SUM ( 'Table'[Planned] ),
FILTER ( ALL ( 'Table' ), 'Table'[date] <= SELECTEDVALUE ( 'Table'[date] ) )
)
If the planed column is written by a measure.
Please have a try.
Measure 2 = SUMX(FILTER(ALL('Table'),'Table'[date]<=SELECTEDVALUE('Table'[date])),[Planned_])
If I have misunderstood your meaning, you can create simple data with excel, then show me the screenshots about the data and the desired output your want.
Best regards.
Hi @simonm8008 ,
I have created a simple sample, please refer to it to see if it helps you.
sum for a calculated column.pbix
Create a measure.
Measure =
CALCULATE (
SUM ( 'Table'[Planned] ),
FILTER ( ALL ( 'Table' ), 'Table'[date] <= SELECTEDVALUE ( 'Table'[date] ) )
)
If the planed column is written by a measure.
Please have a try.
Measure 2 = SUMX(FILTER(ALL('Table'),'Table'[date]<=SELECTEDVALUE('Table'[date])),[Planned_])
If I have misunderstood your meaning, you can create simple data with excel, then show me the screenshots about the data and the desired output your want.
Best regards.
Please check this post Solved: Cumulative Sum using DAX - Microsoft Power BI Community
Thanks,
Ritesh
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
28 | |
22 |