Forum Discussion

yamina's avatar
yamina
Icon for Helper I rankHelper I
2 years 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]) ...
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years 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

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years 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

yamina's avatar
yamina
Icon for Helper I rankHelper I
2 years ago

bhanu_gautam  thank you very much.