For the Power Pivots reports that we build I frequently have to make dozens of calculated fields. Think of Invoiced in the previous year, YoY%, WoW%, Ytd etc, and this for up to 60 measures. That's why I was wondering what in your experience is the quickest way to make a lot of calculated fields which are all very similar. What I usually do now is create all the calculated fields for one measure (for example Invoiced), then copy them to another excel sheet and then use 'ctrl+h' to replace all instances of Invoiced by Margin and then copy them back one by one into the Power Pivot formula bar. It would be really great if there was a way to insert multiple calculated fields simultaneously.
I'm very curious if anybody has a more efficient way to do this! (I'm using Excel 2013)
I'm very curious if anybody has a more efficient way to do this! (I'm using Excel 2013)
