Capture Date Range (Slicer: Relative) 1st and last date using DAX

[mwadhwani]

Hi Experts,

My report has following visual (Slicer : Relative). If I select last 2 months it shows the range at bottom of visul. I want to place this selected range from visual parallel to it. I guess we might achieve this solution using DAX. Below is the screenshot for reference: 

I tried using following DAX : 

Measure = IF(ISFILTERED(d_Date[Data View Range]),CONCATENATEX(VALUES(d_Date[Data View Range]),d_Date[Data View Range]),"")

And display this above measure on Card Visualization. But it shows all the values (means all 60 dates).

I want only the 1st and the last value displayed using DAX. I am close to the solution but not upto it.

Can someone suggest or help me with this query.

Thanks in Advance..!!

[Anonymous]

how to take the values before min and after max

[v-yuezhe-msft · Accepted solution]

@mwadhwani,

You can directly create the following two measures.

minselecteddate = MIN(d_Date[Data View Range])
maxselecteddate = MAX(d_Date[Data View Range])

Here is an example for your reference.



Regards,
Lydia

[hsantosh]

Hi

why for me its not working same DAX i also used, please reply

[mwadhwani]

Thanks @v-yuezhe-msft it worked...!!!!. I was thinking alot so created very complex DAX