Relative Date slicer

[shashankg]

In the relative date slicer, we are interested in:

• Temporal context (e.g. this, last, next)

• Amount input (e.g. 1, 2, 3)

• Period selection (e.g. day, week, month)

For example, based on the image below, we want the output to be “Last 1 Weeks”. We are not interested in the data present in the tables, we only want to know the user’s selection in the date slicer.

[3CloudThomas]

Use SELECTEDVALUE() function - SELECTEDVALUE function - DAX | Microsoft Learn

[shashankg]

No this is not giving correct result