DAX in Power BI

數據分析Power BI最有價值的核心CALCULATE() — 學習資源推薦

UNION: performs the union of two or more tables.

INTERSECT: performs the set intersection between two tables.

EXCEPT: removes the rows of the second argument from the first one.

 

Please check out this blog or video from SQL BI to get more detail.

blog: https://www.sqlbi.com/articles/set-functions-in-dax-union-intersect-and-except/

video: https://www.youtube.com/watch?v=XlCus11OAEk

For some of the more complicated reports, it will be so nice to be able to visualize the connection between the different queries. Also, it seems very beginner friendly so it might encourage more people to start working with Power BI.

https://powerbi.microsoft.com/en-us/blog/announcing-visual-data-prep-public-preview-diagram-view-in-power-query/