SQLBI Newsletter #210

NEW ARTICLE

Differences between INT and CONVERT in DAX

This article describes the small differences between INT and CONVERT in DAX that may end up returning different results in arithmetic expressions.
Read more

#210 · Feb 2022

LEARNING

Course calendar

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

DAX PATTERNS

Basket analysis

The Basket analysis pattern builds on a specific application of the Survey pattern. The goal of Basket analysis is to analyze relationships between events. A typical example is to analyze which products are frequently purchased together. This means they are in the same “basket”, hence the name of this pattern.
Read more

BI-WEEKLY NEWS DIGEST

Latest news

	• Expanding Azure Data Explorer dynamic columns in Power Query By using M, you can transform dynamic columns from Azure Data Explorer into something you can analyze in Power BI! Feb 6, 2022 · Chris Webb
	• Track changes in Power BI Tracking changes of Power BI models and reports is a common requirement without a native solution. This article describes the scenario and how to implement a solution that tracks model changes using Tabular Editor. Feb 1, 2022 · Kurt Buhler
	• Automating the extraction of BIM metadata from PBIX Files using CI/CD pipelines Still on the topic of tracking changes... How can you extract the model metadata from a report if you have not authored the model in Tabular Editor? You can still use the command line version and automate the extraction process through XMLA endpoints. Feb 4, 2022 · Gerhard Brueckl
	• Getting started with the pbi-tools CLI Finally, how do you track changes in the report and not only in the model? Explore this uncharted territory with PBI-Tools, which is your only solution as of today. Feb 5, 2022 · Mathias Thierbach
	• Paired T-Test in Power BI using DAX Why use Power BI with DAX instead of R/Python for statistical analysis? Fully interactive visuals and security restrictions to publish a report in your company portal. Nicely done, Power BI! Feb 7, 2022 · Ben Fedit

SQLBI YOUTUBE CHANNEL

Latest videos

Analyzing related geography attributes in different tables in Power BI