Targeted Value Measure with Gauge

[Louis63]

Hello,

I have data with a turnover per year and I would like to create a gauge that gives the turnover achieved in the current year.

So far, no problem.

I would like to create a measure that would go into "Expected value" to have the previous year's turnover * 10% as the current year's turnover target.

I tried this expression but it doesn't worked :

Expected Turnover = CALCULATE([Total Sales], SAMEPERIODLASTYEAR(DIM_Dates[Date]) * 1.1

Have you any suggestions?

Best

[amitchandak]

@Louis63 , in case of ytd try like

Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31")) *1.1

make sure date table is marked as date table