Please can someone help here, I am going bananas

[dpotta]

I have two tables

1) tblSelection - this only has one row of data

2) tblMatches - this has 4m rows of data

They are joined in a one:many by a field named referenceNumber. Both tables have identical columns

There is a column in both tables called AgeOfCompany. All I want to do is add a column to tblMatches where:

IF (AND(tblMatches[AgeOfCompany] >= tblSelection[AgeOf Company] *0.8 , tblMatches tblMatches[AgeOfCompany] ,<= tblSelection[AgeOf Company] *1.2) then 1 else 0

I am lost as how to do this. If you can help, please do! Obviously, as they are joined, I can only get a 1 in the linked record

[HotChilli]

I can see you are frustrated.

Next time , please provide a (small) data sample.

The column will probably look like this:

ColumnS = IF 
(AND
 (tblMatches[AgeOfCompany] >= RELATED(tblSelection[AgeOfCompany]) *0.8 ,
  tblMatches[AgeOfCompany] <= RELATED(tblSelection[AgeOfCompany]) *1.2),
   1 , 0)

 Please test at your side.