powerbi - Power BI 中的多列排序

Question

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

有谁能够帮我？？

标签： powerbipowerbi-desktop

Answer 1

您可以使用以下公式在查询编辑器中执行此操作：

= Table.Sort(#"Renamed Columns",{{"Status", Order.Ascending},{"Status_count", Order.Descending},{"Duration", Order.Descending}})

这是结果的屏幕截图：