Complex Scenario Modeling

[CGBerylls]

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? 

[amitchandak]

@CGBerylls , I doubt that can easily migrate unless logic is power query of DAX