Forum Discussion

Wattar's avatar
Wattar
Helper 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
amitchandak's avatar
amitchandak
Super User
6 years ago

Wattar , try like

Cible N+1 =
VAR ANNEE_N1 = MINX(Effectif0,Effectif0[Année])+1
RETURN
CALCULATE(SUM(SC[Effectif Cible]);'Dim_Années'[Année]== ANNEE_N1)

Wattar's avatar
Wattar
Helper I
6 years ago

Thanks for you reply, but I get the same result

  • Wattar's avatar
    Wattar
    Helper I
    6 years ago

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

    • v-easonf-msft's avatar
      v-easonf-msft
      Community 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