Forum Discussion
How to implement Left outer, right outer and full outer in Power BI in EDIT Queries ?
Hi
I need to enable left outer join and right outer join after importing the data in Power BI, but i want to implement in Edit Queires
pane, but not using Functions ( NATURALELFTOUTERJOIN ) etc.
can you help me out how to implmenent it in Edit Queires Pane
LEFTOUTER JOIN
RIGHTOUTER JOIN
FULLOUTER JOIN
what is the process if it is import data mode / live connection mode ( seems for live connection we are limited to this functionality ) else need to DAX join functions.
Thanks,
Rams
Hi Anonymous ,
If you can go into Power Query Editor, you will find 'Merge' in the ribbon. All merge types can be found in Join Kind. For more details, please refer to this post: Append vs. Merge in Power BI and Power Query.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- Icey
Community Support
Hi Anonymous ,
If you can go into Power Query Editor, you will find 'Merge' in the ribbon. All merge types can be found in Join Kind. For more details, please refer to this post: Append vs. Merge in Power BI and Power Query.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- amitchandak
Super User
Typically , A measure +0 or The option given below if take care of left and right join.
Measure = Sum(Sales[Sales]) //Filter when no sales
Measure = Sum(Sales[Sales]) +0 //Will show 0 sales.
Force it using
if you need more than one key join in direct query
https://docs.microsoft.com/en-us/dax/combinevalues-function-dax
Other few setting refer : https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-1-Time-Intelligence-in/ba-p/922885
- Greg_Deckler
Community Champion
Right, those are all supported in Merge Queries dialog.
- Greg_Deckler
- Icey
Hi Anonymous ,
Is this problem solved?
Best Regards,
Icey
