Add custom column - query

[hassanh2]

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 ?

[v-jingzhang]

Hi @hassanh2 

DAX and M languages are two different languages in Power BI. They have different functions and syntax. 

Power Query M function reference 

DAX 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

[Vijay_A_Verma · Accepted 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