Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kitcatnj
Frequent Visitor

New Column With Nested IFs

I am analyzing a column and based on what's in there, adding a new column. There are 3 things to check for.

Does the column contain "??",  NULL, and anything not = to 2 char in length

 

This part works. 

-Checking for nulls and ??

= Table.AddColumn(STAGING_workorder, "siteRefGB", each if Text.Contains([siteref], "??") then "BAD" else if [siteref] = null then "BAD" else "GOOD")


Once i add the check for length to the query, it fails. 
IF(LEN ([siteref]) <> 2 then "bad" ) 

 

BUT... If i do a check on ONLY the length, that works. I can't combine them

 

Any help would be appreciated!

1 ACCEPTED SOLUTION
AilleryO
Memorable Member
Memorable Member

Hi,

I (think you missed the M function you need 😉

LEN doesn't exist in M , but Text.Length does 🙂

more info : https://learn.microsoft.com/en-us/powerquery-m/text-length

Hope it helps

View solution in original post

2 REPLIES 2
kitcatnj
Frequent Visitor

THANK YOU !!!! That was it! This now works. 

= Table.AddColumn(TABLENAME "siteRefGB", each if Text.Contains([siteref], "??") then "BAD" else if [siteref] = null then "BAD" else if Text.Length([siteref]) <> 2 then "BAD" else "GOOD")

AilleryO
Memorable Member
Memorable Member

Hi,

I (think you missed the M function you need 😉

LEN doesn't exist in M , but Text.Length does 🙂

more info : https://learn.microsoft.com/en-us/powerquery-m/text-length

Hope it helps

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.