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.
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
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 |
---|---|
45 | |
26 | |
22 | |
12 | |
7 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |