Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I created a relation between 2 tables. Table A contains 2 fields: User Name / Request ID. Table B contains 1 field: User Name (distinct)
The relation works fine and I'm getting Table C with 3 columns: User Name (from Table A) / Request ID / User Name (from Table B).
Is there any way I can change the value of the User Name on Table 3 to YES/NO meaning YES = when the User Name exists and NO when User Name is blank?
Thanks,
Ezequiel
Solved! Go to Solution.
What are you doing to create Table C? With what I'm picturing, you have a relationship between Tables A and B on the UserName. You can then add a new column to Table A called something like ExistsInB, which could show you your Yes/No values. As a True/False, add a new column:
ExistsInB = NOT(ISBLANK(RELATED(Table2[Dealer Name])))
To convert that to Yes/No, wrap it in an IF:
ExistsInB = IF(NOT(ISBLANK(RELATED(Table2[Dealer Name]))), "YES", "NO")
What are you doing to create Table C? With what I'm picturing, you have a relationship between Tables A and B on the UserName. You can then add a new column to Table A called something like ExistsInB, which could show you your Yes/No values. As a True/False, add a new column:
ExistsInB = NOT(ISBLANK(RELATED(Table2[Dealer Name])))
To convert that to Yes/No, wrap it in an IF:
ExistsInB = IF(NOT(ISBLANK(RELATED(Table2[Dealer Name]))), "YES", "NO")
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |