Hello,
I also posted this at Technet and will remove if necessary:
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
Hi Adam,
There isn't enough information for us to troubleshoot, but it looks like you're already going through the process of filling in the blanks on Technet, so not much more we can help with at this stage.
If you don't get it resolved then please come back.
Mynda
