NEW ARTICLE
There are two options to model many-to-many relationships using Tabular and Power BI: you can use either a regular bidirectional filter relationship, or a limited unidirectional relationship. In this article, we compare the performance of both options.
Read more

 
DAX PATTERNS
The Survey pattern uses a data model to analyze correlations between different events related to the same entity, such as customer answers to survey questions. For example, in healthcare organizations the Survey pattern can be used to analyze data about patient status, diagnoses, and medicine prescribed.
Read more

 

SQLBI YOUTUBE CHANNEL
Latest videos
Answering questions: running total and last dates within selection
33:34#unpluggedAlberto Ferrari
Analyzing the parallelism of storage engine operations in DAX Studio
07:31#articleAlberto Ferrari
MOD, QUOTIENT
02:41#daxguideAlberto Ferrari
DIVIDE
01:55#daxguideAlberto Ferrari
Variant
01:07#daxguideAlberto Ferrari
HASONEFILTER
03:11#daxguideAlberto Ferrari

 

BI-WEEKLY NEWS DIGEST
Latest news
• Tabular Editor 2.16.5
The new version of Tabular Editor 2 includes features for GitHub Action workflows and support deploy of partitions governed by incremental refresh. Other bugfixes included.
Nov 30, 2021 · Daniel Otykier
• Create connected PivotTables in Excel for the web
You can now create a PivotTable connected to a Power BI dataset in Excel for the web. The feature was supported to publish model created this way from Excel on Windows. Now you can do the same without Windows, just with a browser. Long life to Excel.
Nov 29, 2021 · Microsoft
• On-premises data gateway November 2021 update
Slow weeks for Power BI update. The only news is that you have to update the data gateway for Power BI. As every month. The real news would be when this is no longer necessary.
Dec 1, 2021 · Microsoft