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] ) )
)

     

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi sarath_chandra 

try like:

UsageCurrentWeek =
VAR _date = MAX(TableName[week date])
SUMX(
    FILTER(TableName, TableName[week date] =  _date ),
    TableName[usage value]
)

UsagePriorWeek =
VAR _date = MAX(TableName[week date])
SUMX(
    FILTER(TableName, WEEKNUM(TableName[week date]) =  WEEKNUM(_date) -1 ),
    TableName[usage value]
)

difference = UsageCurrentWeek - UsagePriorWeek