Forum Discussion
Lookup between two tables
Hi Everyone,
I have to lookup rows between two tables. if one row is completely matching with row in other tables have to create a slicer with same else different. Providing sample data below.
| ID | NAME |
| 1 | XYZ |
| 2 | ABC |
| 3 | XYZ |
| 4 | ABC |
| ID | NAME |
| 1 | XYZ |
| 2 | ABC |
Hi Anand09 ,
Thank you for reaching out to the Microsoft Fabric Community Forum regarding the issue.The following steps may help you to create if one row is completely matching with row in another table
- Go to the "Model" view
- Create a relationship between 2 tables with unique column and go back to the "Data" view.
- Select Table1,create a new calculated column. Below query helps you to create a calculated column.
IF (
RELATED('Table2'[NAME]) = 'Table1'[NAME],
"same",
"different"
)
- Add the new calculated column to the slicer visual, Now select either Same or Different in slicer. Will be able to see the lookup rows between two tables.
- Please find the attached sample file for your reference.
Hope this post helps you. If so, kindly consider accepting it as the solution so that it can assist other members and help them find the answer more quickly.
6 Replies
Hi Anand09, Please try to create a new calculated column with below formula:
RowMatchStatus =
IF(
COUNTROWS(
FILTER(
Table2,
Table2[ID] = Table1[ID] &&
Table2[NAME] = Table1[NAME]
)
) > 0,
"Same",
"Different"
)Try this calculated column
Ensure that search value from table 2 should be unique.Hi Anand09 ,
Thank you for reaching out to the Microsoft Fabric Community Forum regarding the issue.The following steps may help you to create if one row is completely matching with row in another table
- Go to the "Model" view
- Create a relationship between 2 tables with unique column and go back to the "Data" view.
- Select Table1,create a new calculated column. Below query helps you to create a calculated column.
IF (
RELATED('Table2'[NAME]) = 'Table1'[NAME],
"same",
"different"
)
- Add the new calculated column to the slicer visual, Now select either Same or Different in slicer. Will be able to see the lookup rows between two tables.
- Please find the attached sample file for your reference.
Hope this post helps you. If so, kindly consider accepting it as the solution so that it can assist other members and help them find the answer more quickly.
Hi Anand09 ,
Glad that your query has been resolved. If our community member's response addressed your question, please Accept it as answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
Hi Anand09 ,
I just wanted to kindly follow up to see if you had a chance to review my previous response. Please let me know if it was helpful, and feel free to reach out if needed any further assistance. If our community member's response addressed your query, please Accept the answer so that it will be helpful to others to find it more quickly.Thank you.
Hi @Anand09 ,
Glad that your query has been resolved. If our community member's response addressed your question, please Accept it as answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
