Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Get the maximum time stamp as output

Hello,

 

Just wanted to check if there is a way to get the latest timestamp (operation_Date) as output from table 1 -

 

Table 1 -

 

Desired Result -

 

Thanks & Regards

Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Anonymous ,

     

    Or you need a new table to show the  last date stamp for the [ID] and [CC]?

     

     

    table1 =
VAR A =
    MAXX ( ALL ( 'Table' ), 'Table'[timestap] )
RETURN
    FILTER ( ALL ( 'Table' ), 'Table'[timestap] = A )

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous Sure:

    Measure = MAXX(ALL('Table'),[Timestamp])

Column = MAX('Table'[Timestamp])
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you. Columns [ID] and [CC] are two conditions as well. So the desired output would be "what is the last date stamp for the [ID] and [CC]?"

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous ,

     

    Have this king of a measure and use that in the visual filter

    Maxx(allselected(Table),Table[OPeration Date])

     

    Or create measures like this and use in table

    LastNONBLANKVALUE(Table[OPeration Date], max(Table[Concat]))

    LastNONBLANKVALUE(Table[OPeration Date], max(Table[CC]))

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you. I would need the data in a column. And Columns [ID] and [CC] are two conditions as well. So the desired output would be "what is the last date stamp for the [ID] and [CC]?"

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        Or you need a new table to show the  last date stamp for the [ID] and [CC]?

         

         

        table1 =
VAR A =
    MAXX ( ALL ( 'Table' ), 'Table'[timestap] )
RETURN
    FILTER ( ALL ( 'Table' ), 'Table'[timestap] = A )

         

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

         

        Best Regards,

        Dedmon Dai