Forum Discussion

Wattar's avatar
Wattar
Icon for Helper I rankHelper I
6 years ago

Help with calculate

Hello,   I am trying to calculte a measure using this formula: Cible N+1 = VAR ANNEE_N1 = MIN(Effectif0[Année])+1 RETURN CALCULATE(SUM(SC[Effectif Cible]);'Dim_Années'[Année]== ANNEE_N1) whe...
Need Help
Wattar's avatar
Wattar
Icon for Helper I rankHelper I
6 years ago

When I use 2020 instead of the variable it works juts fine

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi , Wattar 

The year field in your measure involves multiple tables.Is the "year" field in the matrix visualization a year in the date hierarchy, or is it a field containing only the year?

 

I'm not sure what effect you want to achieve with your measure.

Could you please share your sample data and desired output screenshots for further analysis?

 

Best Regards,
Community Support Team _ Eason