I already have a solution using a custom column and an If statement but I am just wondering if there is a more elegant solution.
Three tables involved:
1) Financial data comes from the general ledger containing a main account, sub account and an amount.
2) Default Mapping table has all main account numbers and indicates where this account gets reported (e.g. Sales report, line 20)
I merge those two in Power Query. Beautiful.
Third table has a few 'overrides' (i.e., exceptions). When the main account is 1234 and sub account is 999 then I need to override the default mapping (e.g, Cost report, line 100).
I currently merge the override table with the previously combined tables and then use a custom column that says if there is no exception then use the default otherwise use the exception .
Is there a more elegant way to accomplish this?
Three tables involved:
1) Financial data comes from the general ledger containing a main account, sub account and an amount.
2) Default Mapping table has all main account numbers and indicates where this account gets reported (e.g. Sales report, line 20)
I merge those two in Power Query. Beautiful.
Third table has a few 'overrides' (i.e., exceptions). When the main account is 1234 and sub account is 999 then I need to override the default mapping (e.g, Cost report, line 100).
I currently merge the override table with the previously combined tables and then use a custom column that says if there is no exception then use the default otherwise use the exception .
Is there a more elegant way to accomplish this?