topic Re: select MIN date of relative date slicer in every row of table in DAX Commands and Tips

select MIN date of relative date slicer in every row of table

Anonymous — Wed, 26 Aug 2020 15:01:21 GMT

Hi! I have this measure:

Measure = VAR FECHA = CALCULATE(MIN('DATA BASE'[DATE]),ALLSELECTED('DATA BASE'[DATE]),VALUES('DATA BASE'[resp x dep 2])) RETURN FECHA

and in my table is returning me this:

i want to force the measure to only display the values that have information in the MIN date selected in the slicer. Similar as when I select the specific date:

I will use this variable for another measure

Thank you for the help!!

Re: select MIN date of relative date slicer in every row of table

lbendlin — Wed, 26 Aug 2020 16:28:24 GMT

The slicer needs to be fed from an independent date table.

Create a measure that compares your fact date to the min slicer date

Show Row := VAR FECHA = MIN('SLICER'[DATE]) Return 'DATA BASE'[Start]=FECHA

Then filter the visual by Show Row = True

Re: select MIN date of relative date slicer in every row of table

amitchandak — Wed, 26 Aug 2020 17:57:33 GMT

Anonymous , try like

Measure =
var _min = minx(allselected('DATA BASE'),'DATA BASE'[DATE])
RETURN
CALCULATE(MIN('DATA BASE'[DATE]),filter('DATA BASE','DATA BASE'[DATE]=_min ))