王逍凝
/
发布于
/
6369
人观看
Power BI is a business analytics service by Microsoft
展开查看详情
1.Power BI
Power BI is a business analytics service by Microsoft
4.• Table
• Calculated Columns
• Measures
https://docs.microsoft.com/en-us/dax/data-analysis-expressions-dax-reference
6.Calculated Columns
•
'Sales'[Sale]
sales table sale
:
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
