Forum Discussion
How do I get a grand total in PowerQuery M
Duplicate your table > Highlight the column you want to get the grand total from > Transform > Statistics > Sum
Rename 'Table (2)' into something more useful like 'Grand_Total'
Go back to original table > Add Column > Custom Column > enter in whatever you just named the grand totalAll done!
Duplicate your table > Highlight the column you want to get the grand total from > Transform > Statistics > Sum
Rename 'Table (2)' into something more useful like 'Grand_Total'
Go back to original table > Add Column > Custom Column > enter in whatever you just named the grand total
All done!
Now thinking is there an easier way, my thinking is if I duplicate the table and it is pulling data when refreshing then it is refreshing 2 tables with the same data instead of 1 table..
Is Dax an option here ?
