Forum Discussion

Louis63's avatar
Louis63
New Member
3 years ago

Targeted Value Measure with Gauge

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
Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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