Forum Discussion
Kudo KingpinCapture Date Range (Slicer: Relative) 1st and last date using DAX
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..!!
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
4 Replies
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
