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.
I have two tables joined on an ID column. Both tables have a similar field called "Practice", and I need to check if the values are the same. I am trying to use the EXACT function, but when I choose my first field from Table1, it doesn't allow me to pick the second field from TAble2. How do I compare strings of two fields from two different tables?
@Anonymous - Use RELATED or something like MAXX(RELATEDTABLE(...),[2nd Column]).
Since I see that you are a New Member, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
@Anonymous
I am not sure if you are trying a measure, in that case use LOOKUPVALUE function.
If you generate a table try INTERSECT or EXCEPT
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi! @Anonymous
The EXACT function doesnt compare values from two table.
Can you give more information on your Goal.
You can try making a join with Power Query.
= Table.Join(Table1, "Practice", Table2, "Practice")
If I solved your problem please consider marking this as a solution.
It is basically a quality control check. TAble A is from one system, and table B is from another system. Both tables "should" have the same practice name per ID, but they don't always. So I need to find where they don't match so we can do a clean-up.
@Anonymous
You can try like the following example, these two tables will show rows of one table which do not appear in another table.
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
YouTube, LinkedIn
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |