确定删除吗?
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