Forum Discussion

CGBerylls's avatar
CGBerylls
New Member
2 years ago

Complex Scenario Modeling

Hi - I am facing an interesting challenge where I am building a front-end Power BI visualization of a complex Excel model.

 

Essentially, the Excel model has a total of >7k different scenarios that stem from a combination of selections across a series of 10 dropdown lists, each list has between 2-4 possible selections. A change in selection changes the reference assumptions tables and the calculations for over 60 backup tabs. Is there a way to keep in all scenarios (e.g., automate calculation of output tab across all 7k+ scenarios) without essentially recreating the excel workbook in the Power BI workbook? 

1 Reply