NEW JOINS in Power Query! | Power BI update April 2024 (LeftSemi and Right Semi)

Рет қаралды 6,335

2 ай бұрын

Let me show you the new joins that were made available on Power BI Desktop April Update 2024
Join this channel membership to get access to all the recorded bites as they become available:
/ @curbalen
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Mastodon ► @ruthpozuelo@techhub.social
Twitter ► @curbalen
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

Пікірлер: 16

@andrewwalker5974 2 ай бұрын

I just played around with this a little but it looks useful. LeftSemi will return fewer rows than an Inner Join if the second table has duplicates. If A has three rows of "Apple", "Banana" & "Orange" and B is "Apple", "Orange", "Orange" the LeftSemi will return only two rows of "Apple" & "Orange" plus the column of nulls. Useful if we want to reduce a table of orders down to those with item lines in a second table where that second table may have duplicate OrderID.

@CurbalEN 2 ай бұрын

Great! Didnt think about duplicates! :)

@evnpresson7258 2 ай бұрын

I recently discovered their usage within Azure Data Explorer and Kusto and indeed removing duplicates are my main use case.

@barttitulaerexcelbart9400 2 ай бұрын

Mmm, I do' not see the advantage yet, if you do not work with large datasets. In PQ you "only" see the first 1000 rows, and an advantage of the regular joins is that you can have a look if the join was done correct. If you want to clear the dataset with double records you can also to this first. But thanks for the video Ruth: you are a frontrunner!!