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


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


Latest videos


Mastering DAX Video Course
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