Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Dax Formula

Need a DAX formula to Link my Previous week results & Last Week Results to a DATE Slicer.

The Week over Week needs to be dynamic when users want to change the date.

I have used a Relative week filter to create the Week views but not able to link to the date slicer.

 

Not sure I I am just not linking it correct to the measures for the Previous and Last week wheish looks like

Last Week = CALCULATE('table'[CALLS],'Date'[Relative Week Filter]=-1)
Previous Week = CALCULATE('table'[CALLS],'Date'[Relative Week Filter]=-2)
 

I have tryied the IF( selectedvalue('date'[date]) >=

                           [start date] &&

                            selectedvalue('date'[date]) <=

                            [end date],

                            1,

                            0

)

 

 
General Comment
  • amustafa's avatar
    amustafa
    2 years ago

    Try the update measures as following...

     

    Last Week = 
VAR SelectedWeekStart = STARTOFWEEK(SELECTEDVALUE('Date'[Date]))
VAR SelectedWeekEnd = ENDOFWEEK(SELECTEDVALUE('Date'[Date]))
RETURN
CALCULATE(
    SUM('Table'[CALLS]),
    DATESBETWEEN(
        'Date'[Date],
        SelectedWeekStart - 7,
        SelectedWeekEnd - 7
    )
)

     

    Previous Week = 
VAR SelectedWeekStart = STARTOFWEEK(SELECTEDVALUE('Date'[Date]))
VAR SelectedWeekEnd = ENDOFWEEK(SELECTEDVALUE('Date'[Date]))
RETURN
CALCULATE(
    SUM('Table'[CALLS]),
    DATESBETWEEN(
        'Date'[Date],
        SelectedWeekStart - 14,
        SelectedWeekEnd - 14
    )
)

     

     

1 Reply

  • amustafa's avatar
    amustafa
    Solution Sage
    2 years ago

    Try the update measures as following...

     

    Last Week = 
VAR SelectedWeekStart = STARTOFWEEK(SELECTEDVALUE('Date'[Date]))
VAR SelectedWeekEnd = ENDOFWEEK(SELECTEDVALUE('Date'[Date]))
RETURN
CALCULATE(
    SUM('Table'[CALLS]),
    DATESBETWEEN(
        'Date'[Date],
        SelectedWeekStart - 7,
        SelectedWeekEnd - 7
    )
)

     

    Previous Week = 
VAR SelectedWeekStart = STARTOFWEEK(SELECTEDVALUE('Date'[Date]))
VAR SelectedWeekEnd = ENDOFWEEK(SELECTEDVALUE('Date'[Date]))
RETURN
CALCULATE(
    SUM('Table'[CALLS]),
    DATESBETWEEN(
        'Date'[Date],
        SelectedWeekStart - 14,
        SelectedWeekEnd - 14
    )
)