Forum Discussion
How to dynamically calculate row total?
I organized my data in power query and used power pivot to create a pivot table off that data model. I have the years 2019-2023 as columns in this current dataset. However, sometimes when I ...
It seems you did pivot the data inside PQ. And then you did another pivot on top of that which is total ...
The query labeled "3 - Pivot" was just me pivoting the rows into columns so that it displays the year as columns instead of rows.