SUMMARIZE and UNION Dax Functions to Create Customized Tables in Power BI | Step by Step Tutorial

Intermediate tables play a major part when writing very complex designs in Power BI. Please watch below to learn the basics.

Sample code for SUMMARIZE

MIN Table = SUMMARIZE(Sheet1, Sheet1[Name],Sheet1[Subject], "Min Marks", MIN(Sheet1[Marks]) )

Sample code for UNION

Union Table1 = UNION('MIN Table','MAX Table1')