DAX Fridays! #65: EXCEPT

preview_player
Показать описание
In today's video we will continue learning how to join tables using DAX. This time we will use Except to do anti join.

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

ABOUT CURBAL:

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo

#daxfridays #curbal #SUBSCRIBE
Рекомендации по теме
Комментарии
Автор

Great video! I use except a tonne to create “blanks checks”. It’s a hidden sheet in almost all my reports which checks for blanks due to the data source having blank entries for columns (particularly for the linked columns).

learnspreadsheets
Автор

Thanks again Ruth. As a consumer of the information you produce, it would be great to have an index with all the joins. I personally use more than one type in the same situation.

andrecavasotero
Автор

Ruth ...very nice name

I am really excited for dax Friday thanks ruth.. keep sharing 🌹

Dev_Bartwal
Автор

I did not know there was EXCEPT in DAX! It's one of my favorite SQL statements :-) Thanks Ruth

BroadtreeSolutions
Автор

Great series! Glad I discovered it. However, I'm struggling with Except: I have two identical tables, and when I do left or right anti, I get the same rows as a result. Should an Except on two identical table result in an empty table? What am I missing?

kwaaikraai
Автор

Hello, great video. I could definitely use this to compare tables from two different systems :)

juansepowerplatform
Автор

Sorry, but the file is not accessible. Connection not secure and my browser reject it. :-(

myazigi
Автор

Hi Ruth, great video!! I'm new to your channel and I'm enjoying it very much.
Any chance to have the excel file where you show the different types of joints??

Thank you very much for your great work!!

myazigi
Автор

Hi Ruth, I find your videos very useful. I currently have a requirement where I need to do a left anti join. But I have a single table with Date as one of the column and I want to know the difference by date. Ex- What all rows are present in 23rd July and not in 16th July. Many thanks

supriyasingh
Автор

Hi Ruth
nice video, and I have two things:
1) can you please leave a link to download the PBIX file you are working one.
2) could you please explain how to perform the Anti left join, but by outputting all columns from left table not only the column used for matching
thank you very much

majdyazigi
Автор

Great Video .... how can i get the Excel file ?

HusseinKorish
Автор

Hello Ruth!!
I like your videos!!
I have a qestion.
Is it correct to use formula to create table to get the same results:
Left Anti = FILTER('Manuf Products', not 'Manuf Products'[ProductID] in DISTINCT(Stock[ProductID]))

Right Anti = FILTER(Stock, not Stock[ProductID] in DISTINCT('Manuf Products'[ProductID]))

Are they corect?
Best regards

adamowiczjacek
Автор

Não tinha visto essa! Como?? Eu assisto todos! KKKK

powerbinareal
Автор

Hello Ruth ! This video is very interesting and I would like to ask you if you can
My requirement, our client runs some campen on facebook Adboxs
We will fetch date from facebook adbox-clicks, Impression, but the issue
We are able to fetch data-message, Likes, comments, but can't fetch data like clicks and impression.
Please help me

saibigdata
Автор

This video is good but how to do (full outer join) and (anti full outer join)

SKRT_DATA_MUSIC