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.
MFelix
Super User
Super UserHi 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.