Ranking Without any aggregate expression

Hi Anonymous

Try this calculated column

What is the role of Sale ID in RANKING?

SO_Instance =
RANKX (
    FILTER (
        ALL ( TableName ),
        TableName[Customer Id] = EARLIER ( TableName[Customer Id] )
            && TableName[Standing Order Id] = EARLIER ( TableName[Standing Order Id] )
    ),
    TableName[Calendar Date],
    ,
    Asc,
    DENSE
)