Forum Discussion
Solved
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. ...
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!