Right were basically finding the pivot tables in excel are not up to scratch when dealing with large amounts of data.
We have been told that power pivot utilizes the processors better. (Going to have to learn DAX)
If I have the year column which shows 2015 2016 how can I add a column which minuses the 2015 data from 2016.
The column with 2015 2016 is called 'year' I need to add a column which subtracts.
Thanks
Chris
We have been told that power pivot utilizes the processors better. (Going to have to learn DAX)
If I have the year column which shows 2015 2016 how can I add a column which minuses the 2015 data from 2016.
The column with 2015 2016 is called 'year' I need to add a column which subtracts.
Thanks
Chris
Last edited: