I run hundreds of complex Excel scenarios and upload the calculated results to an Access database and use Access queries and reports to compare differences between scenarios. This approach has worked well, but there is a new and expanded version of the model being developed and I’d like to migrate the comparisons between scenarios to powerpivot. I know enough PP to be productive, but am far from being an expert.
My data is laid out in Excel as below (greatly oversimplified)
1999 2000 -------------------------à2020
Sales 50 55 555
Income 20 30 40
My Excel model has about 400 lines with data from 1999 to 2020. Sales and Income above are just 2 of the 300. We typically produce 5- to 100 different scenarios with varying inputs which get uploaded to Access. Scenario1 to Scenario 100, for example.
Management likes to be able to select two scenarios and compare the differences in calculated results for each line.
I’d like to migrate this to PP and would like to get suggestions on how you would approach this with measures etc. I plan on using the existing access database.
Thanks in advance.
My data is laid out in Excel as below (greatly oversimplified)
1999 2000 -------------------------à2020
Sales 50 55 555
Income 20 30 40
My Excel model has about 400 lines with data from 1999 to 2020. Sales and Income above are just 2 of the 300. We typically produce 5- to 100 different scenarios with varying inputs which get uploaded to Access. Scenario1 to Scenario 100, for example.
Management likes to be able to select two scenarios and compare the differences in calculated results for each line.
I’d like to migrate this to PP and would like to get suggestions on how you would approach this with measures etc. I plan on using the existing access database.
Thanks in advance.
