SQLBI Newsletter #211

NEW ARTICLE

This article describes the IN operator in DAX, which simplifies logical conditions checking whether a certain value belongs to a list of values.
Read more

DAX PATTERNS

Currency conversion

This pattern shows multiple scenarios of currency conversion, considering two kinds of currencies: the currency used to collect orders and the currency used to produce the report.

#211 · Mar 2022

LEARNING

Course calendar

Mastering DAX

	Mar 29-31 - Charlotte
	Apr 4-6 - Chicago
	May 18-20 - Copenhagen
	May 23-25 - Amsterdam

Data modeling

	May 23-25 - New York

video courses

	Mastering Tabular
	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	DAX Tools
	Introducing DAX
	Mastering DAX
	Optimizing DAX
	Power Pivot

The pattern covers all the combinations of single and multiple currencies for both source data and presentation.
Read more

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI February 2022 update The biggest and more visible new feature this month is the New Format Pane, which is still in preview but is now active by default. It is a big improvement overall, but it still requires minor fixes. Several other features were released, one of which - mobile formatting options - deserves its own separate article. Feb 17, 2022 · Microsoft
	• Customize format of mobile view of Power BI reports It is now possible to customize the format properties of visuals displayed in the mobile view of a Power BI report. Also, you can now set different font sizes (and much more) between the web view and the mobile view of a report! Feb 17, 2022 · Microsoft
	• TSQL table-valued functions and dynamic M parameters in Power BI DirectQuery Another new Power BI feature in this February 2022 update is the support of dynamic M parameters for several data sources. This article shows how to use parameters with table-valued functions in TSQL. A link for store procedures is included in the article. Feb 20, 2022 · Chris Webb
	• On-premises data gateway February 2022 update Yes, this is your reminder to update your data gateway, thus keeping it synchronized with the Power BI release. The real groundbreaking news will be the automation of these updates! Feb 22, 2022 · Microsoft

SQLBI YOUTUBE CHANNEL

Latest videos

Displaying measures as percentages in Power BI charts