Using PowerShell to create Calculation Groups in Power BI Desktop

Background I recently shared on Twitter a 7-module learning path on MS Learn that teaches all you need to know about calculation groups in Power BI. This learning path is an excellent course, and I highly recommend it. However, as part of this exchange, I received a reply from someone lamenting that calculation groups are Continue reading Using PowerShell to create Calculation Groups in Power BI Desktop

Row-based Time Intelligence

For this blog, I want to share an interesting data modelling technique which you might consider when having performance problems with time intelligence calculations. This particular pattern works well on very large data-sets, especially for visuals that contain multiple measures and multiple periods. The idea is to create a Time Intelligence table which contains blocks Continue reading Row-based Time Intelligence