I need help with formula to add new column called 'multiplier' in table "client_purchase_order_item" where this column should get generated from other column 'unit_id' of the table itself.The dynamic value of 'multiplier' column should be from 'product_units' table 'multiplier' column.
refer to image for a relationship.
example : if( [client_purchase_order_item][unit_id] = [product_units][unit_id],[product_units] [multiplier],1)
I need samething in po_item rooms table as well with same conditions. Please help me with this issue .Thanks in advance for your help.
Solved! Go to Solution.
when i do that on "client_purchase_order_item table", i get an error "The column 'product_units[multiplier]' either doesn't exist or doesn't have a relationship to any table available in the current context".
Since, Product_units table is not directly connected to "client_purchase_order_item" and "po_items_rooms".
Thank you Seward. That was very helpful.
The solution i tried is
1) Multiplier = CALCULATE(
VALUES( 'krimzendev product_units'[multiplier]), FILTER('krimzendev product_units',
'krimzendev product_units'[id]='krimzendev client_purchase_order_items'[unit_id] ))
2) Multiplier = LOOKUPVALUE('krimzendev product_units'[multiplier],'krimzendev product_units'[id],'krimzendev client_purchase_order_items'[unit_id])
Both of the above worked fine. I don't see any difference in the new column values, when compared. Please let me know which is correct one, so that i can maintain the correct formulae across reports.