Letter case sensitivity in DAX, Power BI and Analysis Services

Power BI and Analysis Services are case-insensitive by default. Lowercase letters are identical to uppercase letters. This is mostly a good choice, but it also comes with unexpected consequences. In this video, we run through a set of queries to understand what to be aware of when working with a mixture of lowercase and uppercase strings in DAX.