Forum Discussion
Power Query if statement with condition dependent on Language format
Hi folks, I'm stumped at this problem and tried to make it simpler by chopping the column [Language] into two columns by delimeter "-" but it doesn't seem to solve my issue. So here's what I'...
Your left function doesn't exist. Replace it with Text.Start function.
https://docs.microsoft.com/en-us/powerquery-m/text-start
https://docs.microsoft.com/en-us/powerquery-m/text-start
thanks much JarroVGIT even though this came up in my search never thought about using it.