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 11-May-20 from that which is MINIMUM of Nsp10.

 

 

 

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

3 Replies

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

  • 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
  • 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