Visualizing Merge Join Types in Power BI
You can combine two queries in Power BI using the Merge Queries option (in Edit Queries). While merging queries, you will be asked for a join kind. This report visually shows what are the different j...
Thanks. I see Synoptic's zoom control now. I haven't spent any time with the Visio preview.
Nice work Jason (and great idea too)!
I haven't seen anything explaining joins as simple to understand as your diagram on page 2. As much as the Venn diagram is a classic, the blocks were as straightforward as side-ways Tetris to me (seeing which blocks "fall" to the right-hand column based on their presence and/or absence in the other 2 columns).
Cross joins might be worth adding to the mix (but that would not be fun to do).