NEW ARTICLE
This article explains how the CONTAINS function works, and what are better alternatives in DAX in common use cases. Depending on the use case, TREATAS, INTERSECT, and EXCEPT could be faster and easier to write.
Read more

 
DAX PATTERNS
This pattern shows how to compute time-related calculations like year-to-date, same period last year, and percentage growth using a custom calendar. This pattern does not rely on DAX built-in time intelligence functions. All the measures refer to the fiscal calendar because the same measures, with a regular Gregorian calendar, can be obtained using the Standard time-related calculations pattern.
Read more

 

SQLBI YOUTUBE CHANNEL
Latest videos
Analyzing the last 6 months of sales from the last transaction of each customer
31:54#unpluggedAlberto Ferrari
Exploring attribute hierarchies in Power BI and Analysis Services
36:55#unpluggedMarco Russo
ROLLUPGROUP
01:34#daxguideAlberto Ferrari
TOPN
02:12#daxguideAlberto Ferrari
ROLLUPISSUBTOTAL
02:15#daxguideAlberto Ferrari
EXCEPT
02:57#daxguideAlberto Ferrari

 


BI-WEEKLY NEWS DIGEST
Latest news
• Power BI August 2021 Update
The Power BI August 2021 update has new formatting options for buttons and custom shapes, plus a new way to define date and time constant values without using the DATE and TIME functions.
Aug 13, 2021 · Microsoft
• Enhanced experience for browsing visuals in Power BI
The August 2021 update also has a new browsing experience for custom visuals in Power BI. While the search experience and the classification of the visuals can still be improved, the new visualization is certainly a step forward.
Aug 10, 2021 · Microsoft
• Power BI REST API support for DAX Queries
Microsoft started the preview of a new REST API to get data from Power BI service by running custom DAX queries. This REST API does not use XMLA endpoint and it works on any Power BI subscription, including Power BI Pro. You got that right - no Premium needed. If you want to export data from your dataset to another cloud service, this is a game changer.
Aug 2, 2021 · Ben Gribaudo
• Excel Cube functions, dynamic arrays and lambdas, part 3: grouping and histograms
This new post in the series dedicated to the Lambda helper functions in Excel shows how to dynamically create arguments for the CUBESET and CUBEVALUE functions to create dynamic reports connected to Power BI models.
Aug 8, 2021 · Chris Webb