Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Do value search between two tables

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 yo...
Help appreciated
Help me please
Help Requested
Help required
  • smpa01's avatar
    smpa01
    4 years ago

    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's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

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/