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

Anonymous's avatar
Anonymous
Not applicable
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