topic Re: Do value search between two tables in DAX Commands and Tips

Do value search between two tables

Anonymous — Tue, 16 Nov 2021 16:02:51 GMT

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

Re: Do value search between two tables

Anonymous — Tue, 16 Nov 2021 16:04:55 GMT

Re: Do value search between two tables

jppv20 — Tue, 16 Nov 2021 16:17:51 GMT

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.

Re: Do value search between two tables

Anonymous — Tue, 16 Nov 2021 17:04:04 GMT

Why are you using the blank() function?

Re: Do value search between two tables

VahidDM — Tue, 16 Nov 2021 22:14:13 GMT

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/

Re: Do value search between two tables

smpa01 — Wed, 17 Nov 2021 00:45:38 GMT

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 )