SQLBI Newsletter #183

NEW ARTICLE

The December 2020 version of Power BI introduced new keywords: this article explains the syntax of DEFINE TABLE. The other new syntax (DEFINE COLUMN) was the topic of the article announced in the previous newsletter.
Read more

#183 · Feb 2021

LEARNING

Course calendar

video courses

DAX PATTERNS

Month-related calculations

The month-related calculations pattern describes how to compute year-to-date, same period last year, and percentage growth using a month granularity. This pattern does not rely on DAX built-in time intelligence functions.
Because the pattern does not use real dates to link to sales, you can also implement fiscal calendars with 13 months and any non-standard time-related calculation – provided that the maximum level of detail of the reports is the month and not weeks or days.
Read more

SQLBI YOUTUBE CHANNEL

Latest news

	• Step Folding Indicators for Power Query Online Power Query online is now getting updates sooner than Power BI Desktop. The icon showing where the query folding is stopping is excellent to optimize your access to relational data sources. We hope this feature will soon be landing in Power BI Desktop too! Jan 28, 2021 · Microsoft
	• Power BI Report Server January 2021 release An important update of Power BI Report Server is coming out which includes several features already released in Power BI service. An important note is about the end of Internet Explorer 11 support in August 2021. This is going to impact many businesses, so spread the word! Jan 29, 2021 · Microsoft
	• Data Lakehouse defined If you have heard the latest buzzword, "Data Lakehouse" you might have read another article about the end of the traditional data warehouse. As is often the case, this is an exaggeration as explained in this very good blog post - which also connects the dots with Azure Synapse Analytics. Jan 4, 2021 · James Serra

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.