Forum Discussion
CGBerylls
2 years agoNew Member
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
- amitchandakSuper User
CGBerylls , I doubt that can easily migrate unless logic is power query of DAX