This article shows how to use calculation groups to define a default set of values for columns in your model. Different users can have different default values, and yet retain the full capability to select different values.
Read more
The cumulative total pattern allows you to perform calculations such as running totals. You can use it to implement warehouse stock and balance sheet calculations using the original transactions instead of using snapshots of data over time. The most frequent case of running total is the sum of all the transactions made before a given date. But that same calculation can be used in any scenario where you accumulate values over any sortable column. This is shown in one of the examples of this pattern.
Read more


Latest videos
Implementing the “Top N and others” pattern using calculation groups in DAX
45:03#unpluggedAlberto Ferrari
Customizing the Basket Analysis pattern
20:40#unpluggedMarco Russo
03:25#daxguideAlberto Ferrari
06:29#daxguideAlberto Ferrari
03:37#daxguideAlberto Ferrari
03:48#daxguideAlberto Ferrari


Latest news
• Streaming dataflows in Power BI premium now available in public preview
Streaming dataflows allow authors to connect to, ingest, mashup, model, and build reports but based on continuous streaming, near real-time data. The feature is now available in public preview.
Jul 15, 2021 · Microsoft
• On-premises data gateway July 2021
New connectors supported, alignment with Power BI July 2021 release. It's not exciting to write about the data gateway, but it's always a good reminder to update your gateway.
Jul 13, 2021 · Microsoft
• Power BI dataset refresh, column encoding, and the first partition
If you have large tables with millions of rows and you chase the optimal processing time and compression rate, you want to know how the column encoding is chosen and how this affects the parallelism of the processing.
Jul 11, 2021 · Chris Webb
• Generating Excel reports using Power BI, cube formulas, Office scripts, and Power Automate
It is time to start using Office scripts and Power Automate: this article describes how to produce Excel reports automatically starting from Power BI. If you want to control the layout as only Excel can do, this is a must-read. Very technical, very welcome.
Jul 18, 2021 · Chris Webb
• DAX Studio 2.16.2
There is an important fix in this release for a regression introduced in 2.16.1, which introduced interesting new features. Thus, it is the right time to update DAX Studio, no matter the version you are using now!
Jul 13, 2021 · Darren Gosbell