Power BI

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