Forum Discussion
LOOKUPVALUE returns the wrong item if multiple result_columnName with different capitalization
Take the following case : [Table name STRING_TABLE] ID_STRING STRING_NAME STRING_LANG STRING 1 A EN This is A 2 ...
Anonymous -
You can review this article https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/ for a possible resolution.
ChrisMendoza
Resident Rockstar
Resident RockstarAnonymous -
You can review this article https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/ for a possible resolution.
Interesting read
It indeed solved my problem (adding a trailing zero-width space to the second 'identical' entry) but it's a TERRIBLE SOLUTION!!!
Microsoft people, fix this!!
And it's worth mentionning the problem is also present in SQL Server Analysis Server. Not only in PowerBI.