custom column 2 tables

[160475]

dears,

good day!!

in the pic below you can see 2 columns one called BR_NUM this is from table A and i have last column called Branch From table B 

i would like to creat a column where it says the branch match or not matched

can anyone help please ? 

[v-jingzhang · Accepted solution]

Hi @160475 

If they are columns from two tables, you can create a measure to compare the values. 

Measure =
IF (
    SELECTEDVALUE ( 'table A'[BR_NUM] ) = SELECTEDVALUE ( 'table B'[BRANCH] ),
    "Yes",
    "No"
)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[TomMartens]

Hey @160475 ,

is there a relationship between table A and B, if so what is the cardinality of this relationship? Is Branch a base column, a calculated column, or a measure?

If it's not a base column provide the DAX statement that does the calculation.

Regards,

Tom