New article: Understanding blank row and limited relationships
DAX creates a blank row to guarantee that results are accurate even if a regular relationship is invalid. The blank row is not created for limited relationships. This article shows the effect of not having a blank row in your tables.
Read more


This pattern is a useful technique to compare the value of a measure in different time periods. For example, we can compare the sales of the last month against a user-defined period.
The two time periods might have a different number of days, like comparing one month against a full year. When the durations of both time periods are different, we should adjust the values to make a fair comparison.
Read more


Latest news
• Passing any arbitrary value from a Power BI report to a dynamic M parameter
There is a way to enter any value (and not just a slicer selection) in an M parameter. This is helpful to create dynamic requests for DirectQuery.
Feb 9, 2023 · Chris Webb
• Hacking a bar chart into a table in Power BI
You can create a bar chart in a cell of a Power BI table by using SVG measure, extended Unicode characters, and conditional formatting. The last one requires more creativity!
Jan 2, 2023 · Darren Gosbell


Latest videos
Introducing window functions in DAX
40:58#articleAlberto Ferrari
Counting consecutive days with sales - Unplugged #47
13:52#unpluggedAlberto Ferrari
Welcome to SQLBI+
06:54#announcementMarco Russo