Code | Power Bi | Have conditional Column check for empty instead of null (pulbic)

PHOTO EMBED

Fri Sep 03 2021 06:20:54 GMT+0000 (UTC)

Saved by @Darkleech #vba

= Table.AddColumn(#"Removed Columns2", "The Auditor", each if [Lead Auditor] <> "" then [Lead Auditor] else if [Internal Auditor] <> "" then [Internal Auditor] else if [External Auditor Name] <> "" then [External Auditor Name] else "Unknown")
content_copyCOPY

Create the conditional column with a check for null then manual change the formula to look for empty. E.g. use conditional column to create = Table.AddColumn(#"Removed Columns2", "The Auditor", each if [Lead Auditor] <> null then [Lead Auditor] else if [Internal Auditor] <> null then [Internal Auditor] else if [External Auditor Name] <> null then [External Auditor Name] else "Unknown")