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.
Hi,
I have 2 different tables
1st Table : 14000 names
2 nd table : 25000 names
I would like to add a column to 2nd Table : True if same value as 1st table , False for missing value
Thank you in advance.
Solved! Go to Solution.
Hi @vnqt,
Think this function is what you're after: https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax
Hi,
I do agree with @BITomS if your absolutely need:want to do it in DAX.
My solution would be using a merge in Power Query between both tables.
Let us know if you need more details
Hi @vnqt
many options
Table2[Name] IN VALUES ( Table1[Name] )
or
CONTAINS ( Table1, Table1[Name], Table2[Name] )
or
NOT ISEMPTY ( FILTER ( Table1, Table1[Name] = Table2[Name] ) )
Hi @vnqt
many options
Table2[Name] IN VALUES ( Table1[Name] )
or
CONTAINS ( Table1, Table1[Name], Table2[Name] )
or
NOT ISEMPTY ( FILTER ( Table1, Table1[Name] = Table2[Name] ) )
Hi,
I do agree with @BITomS if your absolutely need:want to do it in DAX.
My solution would be using a merge in Power Query between both tables.
Let us know if you need more details
Hi @vnqt,
Think this function is what you're after: https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |