Data modelling and DAX
Part two in this series on Power BI Aggregation tables focuses on Power BI data models with more than one aggregation table. The first article introduced Power BI Aggregations and included a walk through configuring a Power BI model with a single aggregation table. Intro to Power BI Aggregations Multiple aggregations tables DUAL storage mode … Continue reading Power BI Multiple Aggregations tables
Introduction This is part 1 in a series of articles I plan to write over in the coming weeks regarding the use of Aggregate Tables in Analysis Services databases. Some of the techniques covered in this series have been developed after working on some of the largest models around. The series will cover : Introduction … Continue reading Creative Aggs Part I : Introduction
Did you know, in some cases, it is possible to add columns to your model to speed up the DAX used behind visuals to make them as much as 100 times faster? The PBIX helper file for this article can be downloaded here. I have come across this scenario a few times recently, so thought … Continue reading Speed up Power BI reports using columns
