Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Good people!
I need a help with the following in DAX. I have the table presented below with the data of amounts of each credit and its corresponding data of Amounts and Dates of Settlement and Granting.
As visualized by the RankX measure ( = RANKX (ALLSELECTED('Credits'),[AmountsDiv1000],,DESC,skip) ) iscorrect but I seek to distinguish those with the same amounts in the same way.
How could I use the dates to do it?
I tried as follows without result:
Rank =
As you can see now I managed to get RankX 2 Value to distinguish me both amounts and date values, but using RANKX for those values does not solve me correctly.
Anyway, I seek to see the mistake I am making and how to solve it in some other way.
Of course, thank you very much
Thanks a lot!! 48 hours ago I was trying without resolution
The new RANK function allows you to use multiple criteria for ranking, e.g.
Rank measure =
RANK (
SKIP,
ALLSELECTED ( 'Credits' ),
ORDERBY ( [AmountsDiv1000], DESC, 'Credits'[Fecha Liquidation], DESC )
)