In this article we demonstrate how to use calculation groups to show the behavior of any measure in the last 6 months, starting from a single date selection with a slicer. This can be applied to any number of months.
Read more

The development of enterprise-level models for Power BI Premium and Analysis Services requires both the Microsoft tools and a set of third-party tools – most of them open-source – to get the job done.

This article is the state-of-the-art guide to the development tools for Power BI and Analysis Services models. It provides guidance to improve your productivity and access to new features.
Read more


Latest videos
Consecutive days with no sales
27:35#unpluggedAlberto Ferrari
Increasing compression in Power BI and Analysis Services
28:57#unpluggedMarco Russo
Naming temporary columns in DAX
11:11Alberto Ferrari


Latest news
• Microsoft Business Application Summit recap
Microsoft made a large number of Power BI announcements at the Business Application Summit. While automatic aggregations and hybrid tables (mixing DirectQuery and Import mode partitions) are the most interesting upcoming features for us, you have to read the complete list and watch the related videos to get the full picture of what is going to happen in the next few months.
May 5, 2021 · Microsoft
• Introducing Goals in Power BI
One of the features immediately available in preview is the Goals. This feature is for Premium only, but it is an interesting approach to creating scorecards and KPIs that can be updated manually or automatically by getting data from existing Power BI reports. The automatic snapshot to create a history of the data available in a regular dataset is an intriguing feature we will farther look into.
May 4, 2021 · Microsoft
• Announcing support for backup and restore of Power BI datasets
You can now back up and restore databases in Power BI Premium using the XMLA endpoint. It is thus easier to migrate models and data from Azure Analysis Services to Power BI.
May 6, 2021 · Microsoft
• Power BI connected PivotTables in Excel for the web
You can publish your Excel file with a PivotTable connected to a Power BI dataset and the online version can be navigated as if you were using the local version of Excel. In other words, you can "publish" your Excel report including live PivotTables connected to Power BI. We had been waiting for this feature for too many years!
May 4, 2021 · Microsoft
• On-premises data gateway April 2021 update
This is not only your regular reminder to update your data gateway. This version introduces a feature to test the single sign-on (SSO) configuration, saving you time trying troubleshooting permission issues before going in production.
Apr 27, 2021 · Microsoft
• DAX Studio crowdfunding
Almost 9 years ago, the first beta release of DAX Studio was made available for free. It is time to give back and support Darren Gosbell in continuing the development of new features! If you find DAX Studio useful you can make a one-time donation, or a monthly donation. SQLBI is proud to be the first Gold Sponsor. Your company could be a sponsor too! We look forward to an exciting 3.0 release later this year.
May 1, 2021 · GitHub