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

Подписаться 107 тыс.

Просмотров 17 тыс.

50% 1

What is UNION / INTERSECT / EXCEPT function in DAX
How to perform set operations in DAX
How to merge two tables in DAX
How to find common records between tables
Power bi dax tutorial with examples
#powerbi #powerbidax #union #intersect #except
✉ Business Queries / Analytics Consulting ✉ : analyticswithnags@gmail.com
💬 For Learners Post queries and Interact 💬 : t.me/analyticswithnags
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Power Pivot 📚📖 • Power BI Tutorial (15/...
Power Query 📚📖 • Power BI Tutorial (15/...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Tamil Tutorials 📚📖 • How to do Power BI Ins...
Power BI Telugu Tutorials 📚📖 • How to do Power BI Ins...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
MSBI Tutorials - SQL + SSAS + SSIS 📚📖 • Learn SQL Complete | C...
Data Analyst - Complete Reference - Playlist 📚📖 • Data Analytics For Beg...
BI Developer - Complete Reference - Playlist
📚📖 • Power BI Tutorial From...
BI Architect - Complete Reference - Playlist
📚📖 • Power BI Full Course -...
ETL Developer - Complete Reference - Playlist 📚📖 • Building an Enterprise...
Database Developer - Complete Reference - Playlist 📚📖 • SQL Tutorial - Full Da...

Наука

Опубликовано:

29 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 18

@shubhammishra-ji9oz 2 года назад

The best Dax Functions Playlist on the entirety of RU-vid.

@AnalyticswithNags 2 года назад

Thanks keep learning

@sameerkale7282 2 года назад

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

@AnalyticswithNags 2 года назад

That is in in progress. You can expect it soon

@deebandheiveehan9889 3 года назад

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 3 года назад

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.

@unnamvenkatagowtham7666 2 года назад

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 2 года назад

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

@devender476 2 года назад

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

@AnalyticswithNags 2 года назад

Yes

@gurbajsingh1670 Год назад

Hi where do you download the dataset?

@AnalyticswithNags Год назад

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

@zeeshanahmad-pg6rs 2 года назад

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 2 года назад

Check the Star schema video

@zeeshanahmad-pg6rs 2 года назад

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

@zeeshanahmad-pg6rs 2 года назад

@@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 2 года назад

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 2 года назад

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.