Forum Discussion

sarath_chandra's avatar
sarath_chandra
Icon for Helper III rankHelper III
3 years ago
Solved

Dax help

Hi all, i have week date filter , if i select one date (current week date) and previous week date is prior week date that should be populated in table visual and i need difference of both dynamically...
DAX
Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

     

     

     

     

     

    Usage prior week: =
CALCULATE (
    [Usage current week:],
    OFFSET ( -1, ALL ( 'Calendar'[Year-Wk sort], 'Calendar'[Year-Wk] ) )
)