How do I specify todays date which updates upon refresh?

[Lawro]

Hi

I have added an additional column to compare another columns date for SLA purposes. How do I use Excel's equivalent of today() in power query?

= Table.AddColumn(#"Removed Columns", "SLA status", each if [Task Due By Date] < #datetime(2023, 5, 9, 0, 0, 0) then "Overdue" else "Ongoing")

TIA

 

[AlanSidman]

DateTime.LocalNow()

How to Create Today's Date in Power Query M

Learn how to create the current date in Power Query! You can use Today's date to make your queries dynamic and perform checks on timeliness.

gorilla.bi

 

[Lawro]

Thanks for your help!