Do value search between two tables

[Anonymous]

Hello, 

I have two tables and in one of them I would like to create a column "IS" column which returns the value of "ServiceB" if "nameA" exists in "nameB" otherwise it returns the value "T". Can you please help me do this? 

TABLE A :

Date	NomA	ServiceA
2021-09	toto	yes
2021-09	dream	no
2021-09	fire	hurry

TABLE B :

Date	NomB	ServiceB
2021-09	ice	yes
2021-09	dream	no

[smpa01 · Accepted solution]

@Anonymous  as calculated column

calculatedColumnWithTREATAS = 
VAR _a =
    CALCULATE (
        CALCULATE (
            MAXX ( t2, 't2'[ServiceB] ),
            TREATAS ( VALUES ( t1[NomA] ), t2[NomB] )
        )
    )
RETURN
    IF ( ISBLANK ( _a ), "T", _a )

as measure

measureWithTREATAS = 
VAR _a =
    CALCULATE (
        MAXX ( t2, 't2'[ServiceB] ),
        TREATAS ( VALUES ( t1[NomA] ), t2[NomB] )
    )
RETURN
    IF ( ISBLANK ( _a ), "T", _a )

[VahidDM]

Hi @Anonymous 

Try this:

IS = 
Var _A = LOOKUPVALUE('TABLE B'[ServiceB],'TABLE B'[NomB],'TABLE A'[NomA])
return
if(ISBLANK(_A),"T",_A)

output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[jppv20]

Hi @Anonymous ,

Try this:

IS 2 = IF(LOOKUPVALUE('Table B'[ServiceB],'Table B'[NomB],'Table A'[NomA])<>BLANK(),LOOKUPVALUE('Table B'[ServiceB],'Table B'[NomB],'Table A'[NomA]),"T")

If I answered your question, please mark it as a solution to help other members find it more quickly.

[Anonymous]

Why are you using the blank() function?

[Anonymous]