Power BI is a business analytics service by Microsoft

王逍凝发布于2019/06/06

注脚

展开查看详情

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