MIN DATE FUNCTION

[SIBI1998]

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.

[v-jayw-msft · Accepted solution]

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

[tamerj1]

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

[amitchandak]

@SIBI1998 ,please try measure like

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

or

or min(Table[FROM_DATE])