Forum Discussion

SIBI1998's avatar
SIBI1998
Helper I
4 years ago
Solved

MIN DATE FUNCTION

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 1...
Date DIFF
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

amitchandak's avatar
amitchandak
Super User
4 years ago

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])