SQLBI Newsletter #184

NEW ARTICLE

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 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

#184 · Feb 2021

LEARNING

Course calendar

video courses

DAX PATTERNS

New and returning customers

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

SQLBI YOUTUBE CHANNEL

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

View Web Version · Change Email Preferences · Unsubscribe

You are receiving this email because you have registered to a mailing list from sqlbi.com. If you would like to avoid similar emails in the future, please change your email preferences by clicking the link above.