CALUCLATIONS BASED ON OTHER SIDE OF BRIDGE OR DIRECTLY UNRELATED TABLE

[Anonymous]

I have following model where i where i have introduced a Bridge table.
Now i want this formula or you can say how i can lookup or write a measure/column in Table B base on any Column in TABLE A.

If(TABLE A[BRKG_DT > TABLE B[START_DT,"yes",No")

@Greg_Deckler 

@Rosario 

@
@

I tried lookupvalue IN TABLE B but it throws circular dependency error .

LOOKUPVALE(TABLE A[BRKGT_DT],TABLE A[JOB_NO],RELATED[BRIDGE TABLE[JOB_NO].

[Anonymous]

I need to create this column in Table B

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create calculated column.

Column =
var _index =
MAXX(FILTER(ALL('BRIDGE TABLE'),'BRIDGE TABLE'[JOB_NO]=EARLIER('TABLE A'[JOB_NO])),[JOB_NO])
var _value=
MAXX(FILTER(ALL('TABLE B'),'TABLE B'[JOB_NO]=_index),[START_DT])
return
IF(
    'TABLE A'[BRKG_DT] >_index ,"yes","No")

2. Result:

Best Regards,

Liu Yang

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