DAX Not able to use LEFT, RIGHT or LEN function in Powerbi

[Anonymous]

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

[amitchandak]

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

https://docs.microsoft.com/en-us/dax/text-functions-dax

[Pragati11]

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

[MFelix · Accepted solution]

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.