Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hello
I have 2 tables
table 1 column 1 with all values
table 2 column 1 with same value as table 1 column 1 but not all the value
I want to have a new column in the table 1 which tell me if the value in column 1 is also present in table 2 and this, value per value
ex :
table 1 column 1 | table 1 column 2 | table 2 column 1 | |
a | present | a | |
b | not present | f | |
c | not present | ||
d | not present | ||
e | not present | ||
f | present |
Hope I'm clear
if someone has already found this issue and solved it, please help me
Gilles
Solved! Go to Solution.
Try this for the new calculated column in 'table 1':
column 2 = IF ( COUNTROWS ( FILTER ( 'table 2', 'table 2'[column 1] = 'table 1'[column 1] ) ) > 0, "present", "not present" )
Try this for the new calculated column in 'table 1':
column 2 = IF ( COUNTROWS ( FILTER ( 'table 2', 'table 2'[column 1] = 'table 1'[column 1] ) ) > 0, "present", "not present" )
hello
sorry for my late answer
yes it works
a great thank for your help
Gilles
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |