Forum Discussion
Need help Creating chart with 2 commulative lines in power Bi
- -I am trying to create this in power Bi.
-I m importing this data in excel.
-after unpivoting columns other than first column . I'm getting this data in power Bi.
-to calculate commulative of planned and earned values over time. I'm using this formula to create measure.
" Cumulative Total =
CALCULATE (
SUM('scurve'[Cost]),
FILTER (
ALL( 'scurve'[Date] ),
'scurve'[Date] <= MAX ( 'scurve'[Date] )
))
"
-Which calculates commulative for Planned and earned costs separately in same column.
-the issue is that when I add these fields in chart to show what I want. It doesn't show me accurate commulative lines in chart.
- I want 2 lines showing commulative of planned and earned values here as I posted photo in the beginning of excel chart.
use this measures,
Cumulative Earned Value = CALCULATE( SUM('Table'[Cost]), 'Table'[Cost Type] = "Earned Value Cost", 'Table'[Date]<=MAX('Table'[Date]))Cumulative Planned Value = CALCULATE( SUM('Table'[Cost]), 'Table'[Cost Type] = "Planned Value Cost", 'Table'[Date]<=MAX('Table'[Date]))Thanks,
Arul
3 Replies
use this measures,
Cumulative Earned Value = CALCULATE( SUM('Table'[Cost]), 'Table'[Cost Type] = "Earned Value Cost", 'Table'[Date]<=MAX('Table'[Date]))Cumulative Planned Value = CALCULATE( SUM('Table'[Cost]), 'Table'[Cost Type] = "Planned Value Cost", 'Table'[Date]<=MAX('Table'[Date]))Thanks,
Arul
Thanks for replying but this didnt solve the problem. I'm getting above posted results. I've give the link to excel file & Pbi file as well.
Sorry. It worked when i removed heirarchies from date field. Would aapreciate if you could explain why this doenst work when date is in the form of heirarchies.
