Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I was adding a custom column to my model to map "item code" column to get the for example last 5 digits based on certain prefix in the source column ( using left(Item code column, 5) and in other instances I had to I use "mid" as well as "right" but I got an error message: 'left' name is misspelled!
Aren't these (Left, mid and right) not accepted in query of custom column ?
Solved! Go to Solution.
These are valid in DAX not in Power Query. In PQ, following are the equivalents
MID - Text.Middle
RIGHT - Text.End, Text.EndsWith
LEFT - Text.Start, Text.StartsWith
Hi @hassanh2
DAX and M languages are two different languages in Power BI. They have different functions and syntax.
Power Query M function reference
Can you show your expected result with some dummy data so that we can provide an example solution based on that?
Best Regards,
Community Support Team _ Jing
These are valid in DAX not in Power Query. In PQ, following are the equivalents
MID - Text.Middle
RIGHT - Text.End, Text.EndsWith
LEFT - Text.Start, Text.StartsWith