Combining Tables in Power BI Union Except and Intersect in DAX

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:
https://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: https://learn.radacad.com


Become an academy member: https://learn.radacad.com/academy/


*******************


********
CONNECT with US!
********


--   / radacad_com  
--   / rad_reza  
--   / leila_etaati  
--   / radacad  
--   / leila-etaati-b0304636  
--   / rezarad  
--   / 6393399  
-- https://radacad.com


********