在Power BI中是否存在多重排序的可能性。我有以下表格:
**employee_name** **status** **Status_Count** **Duration**
Arun prasath closed 2 116
Arun prasath open 3 565
Arun prasath unattended 6 1140
Sudip closed 1 46
saran closed 2 67
现在以下是标准:
i) Filter the closed status
ii) Top status count
iii) Shortest time duration
期望的表格输出:
**employee_name** **status** **Status_Count** **Duration**
saran closed 2 67
Arun prasath closed 2 116
Sudip closed 1 46
Can anybody help me??
RANKX()
函数创建一个Rank
列,然后按照排名对名称进行排序。 - Alexis Olson