SUMMARIZE

发布时间 2023-04-06 16:32:09作者: 本大王派你去寻山

 

SUMMARIZE是新建一张表,语法:

SUMMARIZE(TABLE, GROUP BY COLUMN1, ..., GROUP BY COLUMNX, "NEW COLUMN 1", MEASURE 1, ......, "NEW COLUMN X", MEASUREX)

参数TABLE是需要分组的表

参数GROUP BY COLUMN1...X是需要分组的列

参数“NEW COLUMN1”, MEASURE1是派生的列名和度量值

 

使用SUMMARIZE新建一张表:

SUMMARIZE = SUMMARIZE(Sheet1, Sheet1[CATEGORY], Sheet1[PRODUCT], "AMT", [AMT], "MEASURE A", [MeasureA])
新生成的表:

 新生成的表的数据:

 

 

SUMMARIZE可以配合CALCULATE使用:

新建度量值:

SUMMARIZE A = CALCULATE( SUMX(SUMMARIZE(Sheet1, Sheet1[CATEGORY], "AMT", [AMT] * 2), MAX([AMT])))