Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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:
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI 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
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
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:
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
85 | |
77 | |
72 | |
70 | |
55 |
User | Count |
---|---|
106 | |
96 | |
90 | |
79 | |
68 |