DAX measures to calculate same period last month / quarter in Power BI
Create customized DAX measures to calculate same period last month and quarter inside of a calculation group in Power BI.
Published March 22, 2024
Performance impact of visual calculations using DirectQuery in Power BI
Exploring the performance impact of visual calculations in Power BI and how it can be used to optimize DirectQuery mode.
Published February 22, 2024
Parent-child hierarchy without parent key column in Power BI using Python
Learn how to create parent-child hierarchies without a parent key column in Power BI using Python!
Published October 15, 2023
Table filters vs column filters in Power BI and the concept of expanded tables
Are you using table or column filters in your DAX measures? There's a big difference between the two, and it can have a big impact on performance. In this article, I will explain the difference between table and column filters, the concept of expanded tables, show you how they impact performance, and give you 2 examples of how to use table filters effectively.
Published September 2, 2023