Forum Discussion

Geraldine's avatar
Geraldine
Frequent Visitor
10 years ago
Solved

kpi calculations

Hello,

 

QQ, Sorry if this sounds as a very simple / easy question ... Its just that Ive tried in several ways to do this whithout sucess:

 

How Do I get to have in a KPI chart a comparison YTD for 2 variables ? I am trying but what the chart shows me is the last month... please see images , what I need in the chart is the 259 K Vs 308K , not the amount for the last month ....

 

Thank you so much for your help !

 

Need Help
  • Sean's avatar
    Sean
    10 years ago

    Geraldine Try these 2 Measures...

     

    Use YTD Actual in Indicator and YTD Planned in Target Goals

     

    YTD Actual = TOTALYTD(SUM('Table'[Actual]), 'Table'[Date])

YTD Planned = TOTALYTD(SUM('Table'[Planned]), 'Table'[Date])

     

2 Replies

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Geraldine Try these 2 Measures...

     

    Use YTD Actual in Indicator and YTD Planned in Target Goals

     

    YTD Actual = TOTALYTD(SUM('Table'[Actual]), 'Table'[Date])

YTD Planned = TOTALYTD(SUM('Table'[Planned]), 'Table'[Date])