Column Calculations in Excel vs in Power BI

Hi Anonymous ,

I'd file this question firmly in the "it depends" folder.

Assuming that this was a production-standard piece of work that wasn't going to be imminently superseded, and that the raw source data was always going to remain in Excel, I'd say the following:

--1--

All in Power BI. You're going to want everything about that report in one place i.e. just raw data in Excel, then everything else in either Power Query or DAX measures. This means there's essentially only one point of maintenance/failure (the PBIX), and it's more closely controlled and validated.

--2--

See point 1.

However, as this is only a temporary solution and, by your own admission, you're just getting started with DAX, I'd say just keep whatever is in Excel for the sake of speed and simplicity. It's unlikely you'll see any performance, compatibility, or validation impacts in the short-term.

Once you move your raw data source to a DB, my point 1 above will change slightly. At this point, you may want to actually transfer some of the Power Query load to your DB via views or similar but, again, this will also be a closely controlled and validated environment.

Pete