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 )

     

     

     

     

     

jppv20's avatar
jppv20
Icon for Solution Sage rankSolution Sage
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

Why are you using the blank() function?