Forum Discussion
Anonymous
4 years agoNot applicable
Multiply table1 column 1 from table 2 column 2
I have this table here i want to multiply cost from table 1 into sales from table 2 any help? i build a relationship with table 1 and table 2 according to the date with caardianilty many to many and ...
tamerj1
Community Champion
4 years agoHi Anonymous
please create a calculated column in table2
cost per day =
Table2[Sales] * AVERAGEX ( RELATEDTABLE ( Table1 ), Table1[Cost] )