kpi calculations

[Geraldine]

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 !

[Sean · Accepted solution]

@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])

[Geraldine]

Thank you for your help Sean ! 🙂