Тёмный

Combining Tables in Power BI Union Except and Intersect in DAX 

RADACAD
Подписаться 47 тыс.
Просмотров 23 тыс.
50% 1

Power Query is often the engine used for combining data tables, especially using Merge or Append. However, sometimes, you might need to do that operation in DAX. An example of that is when you want to create that combination only virtually as part of a measure calculation that evaluates dynamically. In this article, I’ll explain three DAX functions and what are their meanings: Union, Except, and Intersect.
Read my blog article about this subject here:
radacad.com/combining-tables-...
*******************
Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.
RADACAD courses: learn.radacad.com
Become an academy member: learn.radacad.com/academy/
*******************
********
CONNECT with US!
********
-- / radacad_com
-- / rad_reza
-- / leila_etaati
-- / radacad
-- / leila-etaati-b0304636
-- / rezarad
-- / 6393399
-- radacad.com
********

Наука

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

 

22 авг 2020

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 10   
@londonengland2309
@londonengland2309 3 года назад
You are a star Sir! Thank you for your kind efforts and your explanation is so unique and simple to follow!
@hk_200k
@hk_200k 23 дня назад
amazing. learn something new today.
@RADACAD
@RADACAD 19 дней назад
Glad to hear it!
@gulhermepereira249
@gulhermepereira249 3 года назад
Very clear with your examples, thank you Reza!
@ChrisSmithFW
@ChrisSmithFW Год назад
Thanks, Reza. Fantastic, as always. Do you have any videos that take deeper dives into Union?
@soniyajain7406
@soniyajain7406 2 года назад
Really helpful! Thanks a lot!!
@Search4Knowledge
@Search4Knowledge 2 года назад
Great video!
@franciscoisaacs881
@franciscoisaacs881 3 года назад
Thank you
@stugryffin3619
@stugryffin3619 3 года назад
Thank you Reza. Is it possible to have Dax select all tables to combine based on table name? e.g. Union all tables where name begins with 'x'?
@venkatareddykummitha5863
@venkatareddykummitha5863 2 года назад
VIDEOS ON CONCATENATEX
Далее
Handling MULTIPLE fact tables in Power BI
9:02
Просмотров 297 тыс.
How and why to Create VIRTUAL TABLES in DAX Formulas
18:48
Фэйворит жвачка А? (2024)
01:00
Просмотров 240 тыс.
Set functions in DAX UNION, INTERSECT, and EXCEPT
8:31
Differences between GROUPBY and SUMMARIZE
28:30
Просмотров 33 тыс.
Writing a DAX query using TOPN
14:43
Просмотров 33 тыс.