Forum Discussion
VK_nz
Helper I
Helper IPrevious week value for week group
Hi all, Hoping to get pointer in right direction. I have weekgroup value where I want to show previous week value in the next column 'Previous week' i.e in week starting 26/08 previous week valu...
VK_nz , Try using
DAX
Previous Week =
VAR CurrentWeek = 'YourTable'[WeekGroup]
RETURN
CALCULATE(
MAX('YourTable'[EncounterCount]),
FILTER(
'YourTable',
'YourTable'[WeekGroup] = CurrentWeek - 7
)
)
bhanu_gautam
Super User
Super UserVK_nz , Try using
DAX
Previous Week =
VAR CurrentWeek = 'YourTable'[WeekGroup]
RETURN
CALCULATE(
MAX('YourTable'[EncounterCount]),
FILTER(
'YourTable',
'YourTable'[WeekGroup] = CurrentWeek - 7
)
)
VK_nzbhanu_gautam Thank you, worked perfeclty as intended.