Oct 24 2021 01:02 AM - edited Oct 24 2021 03:52 AM
I have a decision table (general info here) that I would like to use in Excel.
I know how to implement it using nested IFs or Power Query, but is there a simple and efficient way without these? By using some other smart setup or strategy?
Simplified example attached.
Oct 24 2021 01:45 AM
@bartvana Would you mind explaining the logic behind the result table?
Oct 24 2021 03:51 AM - edited Oct 24 2021 03:51 AM
Yes, of course.
The decision table reads like this:
Based on the fact table, I need to fill in the corresponding decision ID for each SKU.
(I just noticed an error in my decision table, corrected file attached, I'll also correct my initial post).
So SKU1 gets decision ID 1 because MulOfVol = 1.
SKU03 gets decision ID 7 because its parameters correspond with this row (where empty fields are irrelevant).
Oct 24 2021 05:59 AM
@bartvana I gladly leave it to someone else.
Oct 24 2021 10:11 AM
Nothing is simple in excel, however you can setup a data model and use measures either in power pivot or Power-Bi to generate your dashboard or report to get the desired results.