我有3-4个不同的值和数据像这样的列
companyname servicestatus employee
abc inservice abc_e1
abc inservice abc_ew1
abc resigned abc_2
abc retired abc_3
abc retired abc_23
def inservice def_12
def inservice def_13
def inservice def_14
def resigned def_3
def resigned def_4
def resigned def_5
def retired def_3因此,当前的数据如下所示
companyname servicestatus count
abc inservice 2
abc resigned 1
abc retired 2
def inservice 3
def resigned 3
def retired 1所以在Power BI上,我想这样展示
companyname joiners leavers
abc 2 3
def 3 4意思是在细木工中,我只想显示在职人员,而在离职者中,我想显示辞职和退休两者。
如何在Power BI中执行此操作

发布于 2018-01-13 00:34:44
从顶部表格开始,添加自定义列(在add Column选项卡下)。
= if [servicestatus] = "inservice" then "joiners" else "leavers"

然后按[companyname]和新的[Custom]列分组。
最后,选择[Custom]列,然后选择Transform选项卡下的Pivot column。在下拉列表中选择Count作为Values列。

发布于 2018-06-08 17:13:00
使用PowerBI桌面的一种方法如下:
<代码>G29

发布于 2019-12-05 14:03:22
分组前的:

分组后的:
= Table.Group(#"Renamed Columns", {"type Num of active days"}, {{"Fitness Distinct users", each List.Sum([Distict Users]), type number}, {"Number of events", each List.Sum([Number of Events]), type number}})

https://stackoverflow.com/questions/48221691
复制相似问题