Forum Discussion

yamina's avatar
yamina
Helper I
1 year ago
Solved

Calculate the week-to-week evolution

Hello 

I want to calculate the week to week evolution

 

evol semaine =
VAR _CurrentWeekCases = CALCULATE(COUNT('Fichiers Sources'[num_dossier]), 'Calendrier'[Semaine ISO]= [Max de semaine S])
VAR _PreviousWeekCases = CALCULATE(COUNT('Fichiers Sources'[num_dossier]), 'Calendrier'[Semaine ISO]= [Max de S-1])
RETURN
    _CurrentWeekCases - _PreviousWeekCases
I don't understand the error message box

 

Can you help me to solve this issue please ? 

 

  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    yamina , Try below mentioned measure

     

    DAX
    evol semaine =
    VAR _CurrentWeekCases = CALCULATE(COUNT('Fichiers Sources'[num_dossier]), 'Calendrier'[Semaine ISO] = MAX('Calendrier'[Semaine ISO]))
    VAR _PreviousWeekCases = CALCULATE(COUNT('Fichiers Sources'[num_dossier]), 'Calendrier'[Semaine ISO] = MAX('Calendrier'[Semaine ISO]) - 1)
    RETURN
    _CurrentWeekCases - _PreviousWeekCases

2 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    1 year ago

    yamina , Try below mentioned measure

     

    DAX
    evol semaine =
    VAR _CurrentWeekCases = CALCULATE(COUNT('Fichiers Sources'[num_dossier]), 'Calendrier'[Semaine ISO] = MAX('Calendrier'[Semaine ISO]))
    VAR _PreviousWeekCases = CALCULATE(COUNT('Fichiers Sources'[num_dossier]), 'Calendrier'[Semaine ISO] = MAX('Calendrier'[Semaine ISO]) - 1)
    RETURN
    _CurrentWeekCases - _PreviousWeekCases