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