Hi, I have a question regarding the dynamic addition of a category in What-If analysis.
Let’s say there is a company which currently has ‘Foods & Beverages’ data as one category with multiple SKUs in it. If they want to check how their profits will change by changing the fields, like variable cost, then we can easily do a what-if analysis for them.
But suppose they come up with a new category ‘Beauty & Health'. Now, is there any automatic way in which power bi can replicate all the work that we did for Food & Bev category for this new category? Can it automatically do what-if analysis on the same field (variable cost)?
Also, in what if analysis we can see only one result. Is there a way where we can create multiple result set so that we can compare them in parallel, like if we change the field by 10% then result will be XYZ and if by 20% then it will be ABC. Can I view them simultaneously?
Thanks in advance!
