Forum Discussion
Divison between two columns from different table and repetitive value.
Hi Everyone,
I need help:
I have two tables Lets say 1&2
Result i want is :
Which is like Amount= If Probill is same add Gross weight and devide it by Freight amount (250.1*90/150)
Any suggestion is highly appreciated.
Hi Anonymous ，
Use the below dax to create a new column:
test = LOOKUPVALUE(Table1[Reeight Amount],Table1[Pro Nmuber],'Table2'[Probill#])*'Table2'[Gross weight]/150Best Regards
Lucien
2 Replies
Anonymous , Join both of them assume it 1 -Many from first table to second
a new measure =
sumx(Table2, calculate( Divide(Table2[Gross weight]* related(Table1[ Freight amount]), sumx(filter(Table2, Table2[Prodbill#] = earlier(Table2[Prodbill#]) ), [Gross weight])) ) )
Hi Anonymous ，
Use the below dax to create a new column:
test = LOOKUPVALUE(Table1[Reeight Amount],Table1[Pro Nmuber],'Table2'[Probill#])*'Table2'[Gross weight]/150Best Regards
Lucien
