Forum Discussion

gcam032's avatar
gcam032
Icon for Helper I rankHelper I
3 years ago

PowerBI dealing with text case differently in M query compared to the data model

Hey Everyone,   I have a dim table that I'm creating from unique values of an existing column in my data model.   I'm taking a field of brands from customers and creating a dim with the following...
Need Help
ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
3 years ago

This is a common issue. M (query editor) is case sensitive, while DAX is not. You will need to make the case match (upper, lower, capitalize) before your remove duplicates.

 

Pat