Forum Discussion

nataliesmiy1357's avatar
1 year ago
Solved

Latest Date and Time

Hello!  How do I make a column that produces the latest date and time?  I have a dataset that has a column of a DateTime (MM/DD/YYYY HH:MM:SS: AM)

 

How do I do this?  I want to create a default of a page of the most recent data.

2 Replies

  • You can add a custom column in Power Query and typing the formula:

    = DateTime.LocalNow() 

    If only you need the date then it's:

    = Date.From( DateTime.LocalNow() )