Forum Discussion

VK_nz's avatar
VK_nz
Icon for Helper I rankHelper I
1 year ago
Solved

Previous 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 value should be '66' (value of week 19/08) 

 

Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    VK_nz , Try using 

     

    DAX
    Previous Week =
    VAR CurrentWeek = 'YourTable'[WeekGroup]
    RETURN
    CALCULATE(
    MAX('YourTable'[EncounterCount]),
    FILTER(
    'YourTable',
    'YourTable'[WeekGroup] = CurrentWeek - 7
    )
    )

2 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Icon for Super User rankSuper User
    1 year ago

    VK_nz , Try using 

     

    DAX
    Previous Week =
    VAR CurrentWeek = 'YourTable'[WeekGroup]
    RETURN
    CALCULATE(
    MAX('YourTable'[EncounterCount]),
    FILTER(
    'YourTable',
    'YourTable'[WeekGroup] = CurrentWeek - 7
    )
    )