

December 18, 2018

Hello,
I also posted this at Technet and will remove if necessary:
https://social.technet.microso.....powerquery
I'm trying to write a query, but it's only returning errors:
if [#"Incident Date "] < Date.AddDays(Date.From(DateTime.LocalNow()),2) and [#"Incident Status "] = "Step 2 - Detailed Report" then "Overdue"
else
if [#"Incident Date "] < Date.AddDays(Date.From(DateTime.LocalNow()),5) and [#"Incident Status "] = "Step 3 - Detailed Report/Normal Sign-Off" then "Overdue"
else
if [#"[Target Completion Date]"] < Date.From(DateTime.LocalNow()) and [#"Incident Status "] = "Step 4 - Investigation" then "Overdue"
else
if [#"[Target Completion Date]"] < Date.From(DateTime.LocalNow()) and [#"Incident Status "] = "Step 5 - Investigation Sign Off" then "Overdue"
else
null
1 Guest(s)
