Forum Discussion
Solved
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 ...
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
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