Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Looking to merge two table on two columns A and B. However, I want to do the following:
Try to match on column A and ONLY IF column A is empty, try to find a match in column B.
What I have now:
#"Merged Queries2" = Table.NestedJoin(#"Merged Queries", {"A","B"}, Activities, {"A","B"}, "Activities2", JoinKind.FullOuter),
Looking for something like (but including the is null for column A condition):
#"Merged Queries2" = Table.NestedJoin(#"Merged Queries", {"A"||"B"}, Activities, {"A"||"B"}, "Activities2", JoinKind.FullOuter),
Is this possible in PowerBI?
I think your answer might be in your question.
Give the Try and Catch a crack?
1. Goodly - Youtube - Try and Catch in Power Query | Smarter way to work with errors in Power Query
2. Error handling - Power Query | Microsoft Docs
Disclaimer: I'm a novice and learning
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 17 | |
| 9 | |
| 8 | |
| 7 | |
| 7 |