Multiply table1 column 1 from table 2 column 2

Question

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 cross filter to both.&nbsp;Table 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Table 2&nbsp;&nbsp;&nbsp;&nbsp;datecostsalescost per day&nbsp;&nbsp;&nbsp;datesalescost per day&nbsp;10/5/2021"cost is fixed at 10 because &lt;2022"70"=" cost *sales per day&nbsp;&nbsp;&nbsp;30/4/202170"="&nbsp; table1[cost] *sales per day&nbsp;10/20/2021&nbsp;40&nbsp;&nbsp;&nbsp;&nbsp;9/29/202167&nbsp;&nbsp;1/5/2022321&nbsp;&nbsp;&nbsp;&nbsp;1/5/202250&nbsp;&nbsp;9/4/2022668&nbsp;&nbsp;&nbsp;&nbsp;9/4/2022190&nbsp;&nbsp;9/5/2022755&nbsp;&nbsp;&nbsp;&nbsp;9/5/202290&nbsp;&nbsp;9/6/2022365&nbsp;&nbsp;&nbsp;&nbsp;9/6/202255&nbsp;&nbsp;9/7/2022489&nbsp;&nbsp;&nbsp;&nbsp;9/7/2022120&nbsp;

tamerj1 · Answer

Hi&nbsp;Anonymous&nbsp;since the relationship is many to many that means in some dates there is multiple costs. Therefore you have to provide a preference on which price would you like to consider; the max, min or average?

anonymous · Answer

well i dont want any of that i just want to multiply the cost by the sales no average no min no max just cost * sale and thats it any clue?

tamerj1 · Answer

Anonymous&nbsp;I believe you misunderstood my reply.&nbsp;in some instances you might not have a single value of the cost rather it will be multiple cost values in a single day. Then providing a preference is not an option it is a must.&nbsp;

anonymous · Answer

thats true but what can i do in that case

tamerj1 · Answer

I guess the average value would be a good estimate? I have no idea about the structure and full meaning of your data. This is a decision that has to come from the business responsible. In the following reply I will post a proposed code&nbsp;

Forum Discussion

Multiply table1 column 1 from table 2 column 2

6 Replies

Related content

Multiply columns

Custom Function to multiply Columns

Multiply Measure by Column

Multiply multiple columns at once based on list of columns

multiplying columns

Table 1					Table 2
	date	cost	sales	cost per day		date	sales	cost per day
	10/5/2021	"cost is fixed at 10 because <2022"	70	"=" cost *sales per day		30/4/2021	70	"=" table1[cost] *sales per day
	10/20/2021		40			9/29/2021	67
	1/5/2022	3	21			1/5/2022	50
	9/4/2022	6	68			9/4/2022	190
	9/5/2022	7	55			9/5/2022	90
	9/6/2022	3	65			9/6/2022	55
	9/7/2022	4	89			9/7/2022	120