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

tamerj1's avatar
tamerj1
Community Champion
4 years ago

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