Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Ranking Without any aggregate expression

Hi Power BI Gurus, I have below set of data    Customer Id Calendar Date Sale Id Standing Order Id 123 14-NOV-13 00:00:00 15264717659 11674594922 123 05-DEC-13 00:00:00 1528509907...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    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
)

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

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
)

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Great it worked like charm... but not surehow ?

May I have to read more article about Earlier...do you have any that explains in detail

 

Thanks

Swapnil