Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello
How can I bring the data from Table 1 to Table 2 using lookup and filter?
If the unique key of table 1 matches the unique key of table 2 & name of table 1 is FF20 return the value from Table 1 to Table 2.
Table 1
unique_key | name | value |
1015422 | FF33 | |
1015422 | FF46 | |
1015422 | FF47 | |
1015422 | Traveller Guid | |
1015422 | FF2 | Apple |
1015422 | FF20 | |
1015422 | FF16 | Test |
1015422 | FF1 | June |
1015422 | FF10 | NA |
1015422 | FF13 | NA |
1015422 | FF3 | NA |
Table 2
unique_key | Supplier Code | FF20 |
1015422 | 12154125 |
Solved! Go to Solution.
Hi, @gauravnarchal
Based on the information you gave, I have created two tables, and the following is my model view.
Please following these steps:
Create a new column named FF20, Here's the DAX expression:
FF20 = MAXX(FILTER(Table1,Table1[name]="FF20"&&Table1[Unique_key]=Table2[Unique_key]),[value])
The following is my preview.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @gauravnarchal
Based on the information you gave, I have created two tables, and the following is my model view.
Please following these steps:
Create a new column named FF20, Here's the DAX expression:
FF20 = MAXX(FILTER(Table1,Table1[name]="FF20"&&Table1[Unique_key]=Table2[Unique_key]),[value])
The following is my preview.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I assume you are Power BI novice if you dont know how to build lookup relationships yet.
Please try do this training before asking basic questions. Thank you ....
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
and
https://www.youtube.com/watch?v=sW5LoDA1ssM
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |