将下面的Rank()Spotfire表达式翻译成Dax查询

Question

如何将下面的Spotfire表达式转换为DAX查询？

Rank(RowId(),"asc",[ACT_ID],[REPORT_END],[ACTIVITY_END_DATE]

Answer 1

如果你想对某个东西进行排名，请使用：

https://dax.guide/rankx/

RankMeasure = RANKX (
'TableNameHere',
[YourMeasureToRankOn],
[OrderOn], ASC/DESC
)