Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
CGBerylls
New Member

Complex Scenario Modeling

‎05-16-2024 01:38 PM

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? 

Labels:
Message 1 of 2
121 Views
0
1 REPLY 1
amitchandak
Super User
Super User

‎05-16-2024 06:58 PM

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



Message 2 of 2
54 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

View All