SQLBI Newsletter #195

NEW ARTICLE

Customizing default values for each user in Power BI reports

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

#195 · Jul 2021

LEARNING

Course calendar

video courses

DAX PATTERNS

Cumulative total

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

SQLBI YOUTUBE CHANNEL

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

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.