Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |