Power Query

[peterf]

Hello community;

I am new to Power Bi and Power Query.

Below is my Power Query, which returns errors for each instance where there is no value in [assignee.emailAddress], how do I cater for this?

= Table.AddColumn(#"Removed Duplicates", "Vendor", each if Text.Contains([assignee.emailAddress], "xxxdata.com") then "xxxdata" else if Text.Contains([assignee.emailAddress], "xxxV1.com") then "xxxV1" else if Text.Contains([assignee.emailAddress], "xxxtechnologies.com") then "tech" else "null")

Thanks in advance

Peter

[peterf · Accepted solution]

SOLVED

This appears to be an old issue going back to 2016 where "null" needs to be the first line in the IF statement, otherwise an error is thrown