Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have a powerquery function adding a new column with some conditions:
= Table.AddColumn(#"Changed Type2", "(C) Enrolled", each if [#"# Enrolled - Copy"] = "NULL" then 0 else if [#"# Enrolled - Copy"] = "TERM" then 0 else if [#"# Enrolled - Copy"] = "DATA" then 0 else if [#"# Enrolled - Copy"] = "SI" then 0 else [#"# Enrolled - Copy"])
I would like to build another condition into this:
IF [Duration COLUMN] is not blank then return 0 in the (C) Enrolled column
I have tried something like this, but can't get it to work
= Table.AddColumn(#"Changed Type2", "(C) Enrolled", each if [#"# Enrolled - Copy"] = "NULL" then 0
else if [#"# Enrolled - Copy"] = "TERM" then 0
else if [#"# Enrolled - Copy"] = "DATA" then 0
else if [#"# Enrolled - Copy"] = "SI" then 0
else if [#"# Enrolled - Copy"] = null AND [Duration COLUMN] IS NOT BLANK then =0
else [#"# Enrolled - Copy"])
Solved! Go to Solution.
If by "blank" you mean null, then try updating the line to
else if [#"# Enrolled - Copy"] = null and [Duration COLUMN] <> null then 0
Note that M is case-sensitive so you need to use "and" instead of "AND".
If [Duration COLUMN] has different types of blanks like the empty string "" or white space " ", then use those instead of null above.
If by "blank" you mean null, then try updating the line to
else if [#"# Enrolled - Copy"] = null and [Duration COLUMN] <> null then 0
Note that M is case-sensitive so you need to use "and" instead of "AND".
If [Duration COLUMN] has different types of blanks like the empty string "" or white space " ", then use those instead of null above.