Forum Discussion

yaseenhamid's avatar
yaseenhamid
Frequent Visitor
3 years ago
Solved

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 calcula...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Arul's avatar
    Arul
    3 years ago

    yaseenhamid ,

    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

yaseenhamid's avatar
yaseenhamid
Frequent Visitor
3 years ago

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.