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?