Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to Solution.
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
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")
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
User | Count |
---|---|
88 | |
88 | |
74 | |
67 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |