1.Power BI Power BI is a business analytics service by Microsoft 

2.• • • • 

3.DAX 

4.• Table • Calculated Columns • Measures https://docs.microsoft.com/en-us/dax/data-analysis-expressions-dax-reference 

5.Table • 

6.Calculated Columns • 'Sales'[Sale] sales table sale : 

7.Measures • • • 

8.Aggregation Function • SUM • AVERAGE • MIN • MAX • Only for on column 

9.X Aggregation Function • SUMX • AVERAGEX • MINX • MAXX • table 

10.• Filter functions • FILTER(<table>,<filter>) • ALL(<table> or <column>) • RELATED(<column>) • CALCULATE(<expression>, <filter1>,<filter2>…) 

11.beijing@dataapplab.com