Divide 2 different columns from different tables power bi

[chelly911]

Hello 
hello i have 2 different tables I want to divide Table 1 value with Table 12 conversion rate 
there is a relationship between table 1 date and table 2  date 
chatgpt and other resources recommending 
DividedValue = SUM('table1'[value]) / SUM('table2'[converstion rate])
but i don't want to sum what should i do 
thanks 

	table1			table 2
date	value		date	conversion rate
2020-01	500		2020-01	3.3
2020-01	100		2020-02	3.1
2020-02	1000		2020-03	3.2
2020-04	100		2020-04	3.12
2020-04	150		2020-05	3.4
2020-04	220
2020-04	225
2020-04	50

[JoBI]

Hello,

If you want to divide all values from table1 with values of table2, you can create a new column in table1 (assuming there is a many:1 active relatioship):

DividedValue = table1[value] / RELATED(table2[conversion rate])

Hope this helps

[chelly911]

Thanx for answering i get this error "A single value for column 'value' in table 1  cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."
also in the measure when i refer to the table 1 value i get a red line in value  "cannot find name [value]  "
and parameter is not in the correct type for table 2 table2[conversion rate] 
thanks