Power BI DAX Tutorial (23/50) - What is UNION Intersect Except in DAX

[@shubhammishra-ji9oz]

The best Dax Functions Playlist on the entirety of KZbin.

[@AnalyticswithNags]

Thanks keep learning

[@deebandheiveehan9889]

Hi Nags, I like the way you explain the concepts , Need one clarification in the above video on difference between UNION and UNION ALL operators , Is it UNION will return all the records from both the tables with duplicates removed UNION ALL - will return all the records from both the tables with duplicates included Whether my understanding correct ?. Keep posting videos , Thanks for your noble work...

[@AnalyticswithNags]

Yes. Your understanding is correct. This is applicable to SQL. But, in case of DAX there is no Union All function Only union function in dax , which will retain the duplicate. You can use distinct on top of union to remove duplicate.

[@devender476]

Sir before performing union, the table should have same number of columns and same datatypes ??

[@AnalyticswithNags]

Yes

[@sameerkale7282]

Sir please create an end to end project for DAX that will help us alot 🙏

[@AnalyticswithNags]

That is in in progress. You can expect it soon

[@unnamvenkatagowtham7666]

Sir I think while computing the max chennai sales or min bangalore sales I think we should keep the expression as max(sales(sales quantity) instead of max(sales(sales amount) since in the output tables of either max chennai sales or min bangalore sales we have columns as product name and max quantity. I am sure that max quantity is the alias name. I have a doubt that what is meant by total sales either it comes for the total sales amount or total sales quantity please correct me bro

[@AnalyticswithNags]

Ignore any typo or mistakes done in the column mapping or naming. You need to understand the concept union or intersect. That is the main purpose of this video

[@gurbajsingh1670]

Hi where do you download the dataset?

[@AnalyticswithNags]

Check description. If it is not there practice with your own dataset

[@zeeshanahmad-pg6rs]

if i have location column in separate table, product name in separate table and salesamount in seperate table then how i can achieve this?

[@AnalyticswithNags]

Check the Star schema video

[@zeeshanahmad-pg6rs]

@@AnalyticswithNags there is no video related to star schema in this playlist. Please provide the link.

[@zeeshanahmad-pg6rs]

@@AnalyticswithNags and on more question. I want to calculate the running value for the active employees and terminated employee if a employee join it increase the value and if an employee terminated it decrease the value according to date. How i can achieve this? Thanks in advance.

[@batchu77]

Oh my god, so confusing only you are confident in explaining the stuff which you are assuming everyone is understanding, for bangalore you chose min and column name is max....how can beginners understand sir, you are really not good at teaching just overconfident way of doing things...

[@AnalyticswithNags]

It is easy to comment on the video. The focus of this video should be on union or intersect or except, for this I can create a prior to the video and use this function in 3 mins. No one told you, why you need those individuals tables or how to create. If this channel not works for you. please move on. Yes I am confident about my knowledge.