Pro tips to optimize Power BI data modeling: automating manual tasks
Optimize your Power BI data modeling development. Explore advanced techniques, from creating DAX measures in Tabular Editor with C# to ensuring referential integrity. Accelerate development with efficient DAX formatting, robust date tables, metadata updates, source connection parameterization and more.
Published December 13, 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
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