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 function, but old video have not sure what changed? https://www.youtube.com/watch?v=zXsjWrYwgWQ
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.
3 Replies
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.
Hi Anonymous ,
You are creating this at wrong place. Query editor supports M code not DAX.
LEFT is a DAX function.
For DAX go out of query editor and create as follows:
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
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
