topic Re: Calculate the week-to-week evolution in DAX Commands and Tips

Calculate the week-to-week evolution

yamina — Fri, 13 Sep 2024 08:53:36 GMT

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 ?

Re: Calculate the week-to-week evolution

bhanu_gautam — Fri, 13 Sep 2024 09:16:30 GMT

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

Re: Calculate the week-to-week evolution

yamina — Fri, 13 Sep 2024 09:43:46 GMT

bhanu_gautam thank you very much.