powerbi, 多维度排序 

排1名 = 
VAR CurrentCategory = 'Sheet1'[大类]
VAR CurrentSupplier = 'Sheet1'[供应商]
VAR CurrentYearMonth = 'Sheet1'[年月]
VAR CurrentAmount = 'Sheet1'[金额]

RETURN
    RANKX(
        FILTER(
            ALL('Sheet1'),
            'Sheet1'[大类] = CurrentCategory &&
            'Sheet1'[供应商] = CurrentSupplier &&
            'Sheet1'[年月] = CurrentYearMonth
        ),
        'Sheet1'[金额],
        CurrentAmount,
        DESC,
        DENSE
    )

　　

按大类, 供应商, 年月 3个维度分组, 组内对金额排序,dense模式, 金额倒序

posted @ 2025-07-22 16:03  CrossPython  阅读(16)  评论(0)    收藏  举报