Non Matching values from another table

Hi Tob_P ,

Please follow these steps:

You are using LOOKUPVALUE to return an incorrect value because an Opportunity (tober_opportunityid) in the Bidding Con table may have more than one corresponding value, and the result of the Calculation Column will only show one value, so the Calculation Column doesn't know which value to get at this time. So you can refer to the following solution:

Based on your description, I created two tables and the relationship between them as follows.

1.Create a calculated column in the Opportunity table and write the following formula.

Column =

var _select=

SELECTCOLUMNS(FILTER(ALL('Bidding Con'),'Bidding Con'[Opportunity(tober_opportunityid)]=EARLIER('Opportunity'[opportunrityid])),"column",[Value])

return

IF(

    'Opportunity'[Value] in _select,1,0)

2.The result obtained is shown below.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.