Forum Discussion
Excel to build commercial model
I`m building a commercial model for project evaluation with multiple scenarios, I usually do as excel regular sheets, but I`m trying to go for power Query & Pivot model, but for the complexity of dat...
In general, Power Query could be considered as structured data source for the data model. With help of it you transform raw data in proper way and load to data model. Based on it you could build different reports (PivotTable or structured table or cube formulae) for the scenarios. Parameters of the scenarios also could be loaded into data model by Power Query.
That's in general, evil is on details.
SergeiBaklan The main point for me is how to goal seak with tables in power query and tables models. Maybe the cubes formulas is a way out for this.
Afraid there is no goal seek in the data model from the box. There are some workaround, but they very depends on concrete data structure and your own logic for goal seek in scenarios.
