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 article, we run through a set of queries to understand what to be aware of when working with a mix of lowercase and uppercase strings in DAX.
Read more


The new and returning customers pattern helps in understanding how many customers within a given time period are new, returning, lost, or recovered. There are several variations to this pattern, each with different performance and results depending on the requirements. Moreover, it is a very flexible pattern that allows the identification of new and returning customers, or the computation of these customers’ purchase volume – also known as sales amount.
Read more


Latest videos


Mastering DAX Video Course
Latest news
• Best practice rules to improve your model’s performance
What is the tool Microsoft uses (and recommends) to validate best practices for a Power BI or Analysis Services model? Tabular Editor.
Microsoft has defined a set of rules for the Best Practices Analyzer feature available in Tabular Editor.
Be careful: the article includes just a list of items. Their full description is visible by opening the rules in Tabular Editor, or in a text editor if you enjoy reading JSON files.
Moreover, it is a starting point.
Several of the rules might be useless for small to medium-sized models: choose the ones that are relevant for you, and ignore the others.
Microsoft creates very large models for internal use.
It would be nice to know which editor they use for that.
Just saying...
Feb 3, 2021 · Microsoft
• Tabular Editor 2.14.1
Remember to update Tabular Editor, especially if you deploy models to Power BI Premium through XMLA endpoints: the new TOM libraries might be required.
Feb 11, 2021 · Daniel Otykier
• Power BI Embedded Generation 2
Microsoft started the preview phase of Power BI Embedded Gen 2. Just like Power BI Premium, Embedded Gen 2 introduces enhanced performance and flexibility in using your capacity.
Feb 7, 2021 · Microsoft