Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I have two tables with multiple columns and i need to verify if some values are in one and others in another. The problem is i cannot merge as then it creates circular flow and Power Bi doesnt like it. There isnt a straight Vlookup way of adding the columns from one to another in Query (or i havent found one yet). When Lookup using DAX i can find and then filter true and false, but as i need lets say 3 different columns to be filtered: example if(A=True, then set B=True, else set C=True) here A,B, C are the values that were LOOKEDUP from one of the tables. Any ideas how to approach this problem?
Solved! Go to Solution.
Actually, that didnt seem to be what i was looking for, however your suggestion gave me another idea speaking of conditions, and so i applied the if statemnts on the LOOKUPVALUEs that way i already got my TRUE and FALSE from that output, and then when i was doing the additional checks this time Power Bi was accepting them as before I was keep getting an error for true and false not possible to filter in such ways, but i guess just needed to find another step before that, so thanks in the end i got to where i needed 🙂
Actually, that didnt seem to be what i was looking for, however your suggestion gave me another idea speaking of conditions, and so i applied the if statemnts on the LOOKUPVALUEs that way i already got my TRUE and FALSE from that output, and then when i was doing the additional checks this time Power Bi was accepting them as before I was keep getting an error for true and false not possible to filter in such ways, but i guess just needed to find another step before that, so thanks in the end i got to where i needed 🙂
@partymia
Glad you found a solution at the end, do let me know if you face any issues.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@partymia
You can use LOOKUPVALUE function with more than one condition and find matching value, please refer : https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
70 | |
68 | |
43 | |
34 | |
26 |
User | Count |
---|---|
86 | |
50 | |
45 | |
38 | |
38 |