Forum Discussion
DAX Not able to use LEFT, RIGHT or LEN function in Powerbi
I am trying to use LEFT and LEN function to separate on a column in Power Query. but I am not able to use. Not sure what went wrong? system not recognize the LEFT .. I did google is DAX having left ...
Hi Anonymous ,
DAX as LEFT RIGHT and LEN, however you are on the query editor and Query Editor uses M language in that you don't have those function you need to use:
- Text.Start = LEFT
- Text.End = RIGHT
- Text.Lenght = LEN
Check the link below with a full description of text functions in M language.
https://docs.microsoft.com/en-us/powerquery-m/text-functions
Dax is used on the front-end of desktop.
I edit Query you have to use M. And most functions are Text.*
Like Text.left and text.right
https://docs.microsoft.com/en-us/dax/text-functions-dax
In Dax you have left, right