Slicer Relative date range values in the table as a column

[Anonymous]

Hi Expert,

Is it possible to show the slicer date range values in the table as a column.

The range being the selections made by the users on the slicer. Please find attached image which has the screenshot of the slicer with the relative date setting.

What I am looking is to have the date range column in the table which shows the values '1/12/2021 - 30/05/2022' as the row values in the table.

Appreciate your help.

[Anonymous · Accepted solution]

I think I fond how to do it.

Created a measure as below and it worked:

SelectedDateRange = 
Concatenate(Concatenate(CALCULATE( MIN('Date'[Date]), ALLSELECTED('Date'[Date]) ),"-"),CALCULATE( MAX('Date'[Date]), ALLSELECTED('Date'[Date]) ))