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
How to handle different granularities in Power BI
Picture this for example: you are dealing with your daily sales figures and suddenly you need to compare them with long-term yearly targets. This request comes very often from stakeholders. How would you handle this in your data model? DAX? Well like almost everything in Power BI, there is more than one solution…
Published August 15, 2023