Get values from filter using a measure

[Anonymous]

I have a filter with relative date applied to a visual / page and I would like to display selected period on the report, so it can change dynamically.

Is there a way to get relative filter values (dates) using DAX?

Thanks!!

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

You need to create a consecutive calendar table.

Then you can use 'Min'/'Max' to get the earliest/ latest date in relative date slicer and disply them in each card.

Earliest date = Min('Calendar'[Date])

latest date = MAX('Calendar'[Date])

You can also concatenate the results as follows in a single card.

Date Range = FORMAT( MIN('Calendar'[Date]),"yyyy-dd-mm")&"~"&format(MAX('Calendar'[Date]),"yyyy-dd-mm")

Best Regards,
Community Support Team _ Eason

[Anonymous]

That's exactly what I was trying to do. Didn't think about using MAX and MIN.

Thank you @v-easonf-msft !!

[amitchandak]

@Anonymous , You can do that with an independent date table and period slicer

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-30/m-p/1284966#M561629