Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
31 | |
31 | |
20 | |
15 | |
12 |
User | Count |
---|---|
19 | |
18 | |
16 | |
9 | |
9 |