Decision table (without nested IFs or Power Query)

Question

I have a decision table (https://en.wikipedia.org/wiki/Decision_table) 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.

riny_van_eekelen · Answer

bartvana&nbsp;Would you mind explaining the logic behind the result table?

bartvana · Answer

Yes, of course.The decision table reads like this:if MulOfVol = 1, then ID 1 (the other parameters are irrelevant in this row, that's why they are empty)if MulOfVol = 0 and Custom = 1, then ID 2...if SKUCrit01Fail = 1 and SKUCrit02Fail = 1 and SKUCrit03Fail = 1, then ID 5Based 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&nbsp; gets decision ID 7 because its parameters correspond with this row (where empty fields are irrelevant).

riny_van_eekelen · Answer

bartvana&nbsp;I gladly leave it to someone else.

yea_so · Answer

bartvana&nbsp;&nbsp;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.

Forum Discussion

Decision table (without nested IFs or Power Query)

4 Replies

Resources