topic Re: MIN DATE FUNCTION in DAX Commands and Tips

MIN DATE FUNCTION

SIBI1998 — Wed, 20 Apr 2022 05:52:52 GMT

Hi Everyone,

Here I have Stuck with MIN DATE function from FROMM_DATE ; from mx APBDR we have 3 Same Values of NSP10 and 3 Different Values in FROM_DATE.

I have need only 11-May-20 from that which is MINIMUM of Nsp10.

Re: MIN DATE FUNCTION

amitchandak — Wed, 20 Apr 2022 06:05:48 GMT

SIBI1998 ,please try measure like

minx(filter(allselected(Table), Table[mx APBDR] = max(Table[mx APBDR]) ), Table[FROM_DATE])

or min(Table[FROM_DATE])

Re: MIN DATE FUNCTION

tamerj1 — Wed, 20 Apr 2022 06:10:32 GMT

Hi SIBI1998

place this measure in the filter pane of the table visual and select "Is" and inset the value 1 then apply

Filter Measure = VAR CurrentDate = MAX ( Table[FROM DATE] ) VAR MinDate = MINX ( CALCULATETABLE ( ALL ( Table ), ALLEXCEPT ( Table, Table[mx APBDR] ) ), Table[FROM DATE] ) RETURN CurrentDate = MinDate

Re: MIN DATE FUNCTION

Anonymous — Mon, 25 Apr 2022 10:06:10 GMT

Hi SIBI1998 ,

Create a measure like below and add it to visual filter set value = 1.

measure = IF ( SELECTEDVALUE ( [FROM_DATE] ) = MINX ( ALLEXCEPT ( 'table', [mx apbdr] ), [FROM_DATE] ), 1, 0 )

Best Regards,

Jay