Forum Discussion

her's avatar
her
Helper III
7 years ago
Solved

Last Date & Time Refresh

How to update the last Date & Time in Dax query?

 

Thanks

Regards

Herwin

Need Help
Show and Tell
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi her ,

     

    If you use a measure to get the last date in a table, it would be updated automatically according to the changes in data source. You can display below measure in a card visual.

    LastDateTime=MAX(Table[Date])

     

    Best regards,

    Yuliana Gu

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi her ,

     

    If you use a measure to get the last date in a table, it would be updated automatically according to the changes in data source. You can display below measure in a card visual.

    LastDateTime=MAX(Table[Date])

     

    Best regards,

    Yuliana Gu