NEW ARTICLE
This article describes how to return BLANK instead of zero in a DAX measure. Using this technique, you can remove rows in a Power BI matrix visual where the result of a measure is zero.
Read more

 

DAX PATTERNS
This pattern includes several coding techniques you may find useful for budgeting scenarios.
The techniques do not apply only to budgeting. We use the budget as an example to show how to reallocate a measure at a different granularity, and how to combine measures coming from tables with different granularities into the same chart.
Read more

 

BI-WEEKLY NEWS DIGEST
Latest news
• Dataset backup and restore performance just got a lot better
Microsoft made considerable progress in the backup time of datasets in Power BI service. The performance improvements in the restore features are there as well, but only marginal compared to those of backup.
Mar 7, 2022 · Microsoft
• Refreshing Excel Power Query queries with VBA and Power Automate for Desktop
You can use Power Automate to execute (or delete) individual Power Query queries. This article is interesting for two reasons: the use case of Power Automate, and the VBA functions introduced in Excel a few months ago.
Feb 27, 2022 · Chris Webb

 


SQLBI YOUTUBE CHANNEL
Latest videos
DAX by examples
71:50#videoAlberto Ferrari
Understanding the IN operator in DAX
15:48#articleAlberto Ferrari
SQRTPI, PI
00:57#daxguideAlberto Ferrari
ISFILTERED, ISCROSSFILTERED
03:13#daxguideAlberto Ferrari
RAND, RANDBETWEEN
02:14#daxguideAlberto Ferrari
BLANK
01:49#daxguideAlberto Ferrari