Forum Discussion
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 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 |
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 )
5 Replies
jppv20Solution Sage
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.- VahidDM
Super User
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/ 
smpa01Community Champion
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 )
