Forum Discussion
Solved
Add custom column - query
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 ot...
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