Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
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.
Pallavi
Solved! Go to Solution.
Add a calculated column to "client_purchase_order_item"
Multiplier = RELATED(product_units[multiplier])
Hi ,
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
Pallavi
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] ))
or
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.
Thank You
Pallavi
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |