Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello
Need to find if a value is in another table.
Has a table that contains inventory numbers (List).
Has two tables containing inventory (List_1 and List_2).
Want to add two columns that contain a "Yes" or "No" depending on if the value found in the other tables.
The tables containing inventory can have the same inventory number more than once.
Solved! Go to Solution.
Use in values(), this is very simple to check if a value in others columns or tables.
Is in 1 = IF(List[ID] in VALUES(List_1[ID]),"Yes","NO")
Is in 2 = IF(List[ID] in VALUES(List_2[ID]),"Yes","No")
Best regards
Paul Zheng
Use in values(), this is very simple to check if a value in others columns or tables.
Is in 1 = IF(List[ID] in VALUES(List_1[ID]),"Yes","NO")
Is in 2 = IF(List[ID] in VALUES(List_2[ID]),"Yes","No")
Best regards
Paul Zheng
Try
Is in 1 = if(isblank(countx(filter(list1,list1[ID]=list[ID]),list1[ID])),"No","Yes")
Is in 2 = if(isblank(countx(filter(list2,list2[ID]=list[ID]),list2[ID])),"No","Yes")
Appreciate your Kudos.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
80 | |
61 | |
60 | |
58 |
User | Count |
---|---|
155 | |
119 | |
103 | |
77 | |
71 |