Pre-calculated aggregations for Power BI — Why should you avoid them

One of my clients always wants to pre-calculate aggregation in his Excel files, which he then uses in Power BI. Here’s why we should avoid doing this.

Salvatore Cagliari

Published in

Towards Data Science

5 min readApr 19, 2022

Introduction

Written by Salvatore Cagliari

848 Followers

Writer for

Towards Data Science

Nerd passionate about technology, and space science and interested in many other things. On the Business side, an expert in Data Analytics and Power BI.

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams