DAX Min Date of Min Value

[vj82reddy]

Hello Folks,

here im trying to write a DAX expression,

Date	Visbility
2022-06-26  08:00	300
2022-06-26  09:00	100
2022-06-26  10:00	200

i would like to retrieve MIN Date for MIN Visibility

which translates to SQL as below,

select MIN(Date) from table where visibility =(select MIN(visibility from Table)

can you sugest the DAX query (expected Value MinDate 2022-06-26 09:00)

[vj82reddy]

Thank you very much this worked

[amitchandak · Accepted solution]

@vj82reddy ,

New measure =

var _min = minx(allselected(Table), Table[Value])

return

minx(filter(Table, Table[Value] = _min ), Table[Date])

or

New measure =

var _min = minx(allselected(Table), Table[Value])

return

minx(filter(allselected(Table), Table[Value] = _min ), Table[Date])