Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

 

Screenshot 2020-04-20 at 17.03.04.png

 

 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

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
Super User
Super User

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:

l1.png

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

MFelix
Super User
Super User

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.