Please can someone help here, I am going bananas

dpotta — Thu, 21 Jan 2021 23:59:54 GMT

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

Re: Please can someone help here, I am going bananas

HotChilli — Fri, 22 Jan 2021 02:00:35 GMT

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.

topic Please can someone help here, I am going bananas in DAX Commands and Tips

Please can someone help here, I am going bananas

Re: Please can someone help here, I am going bananas