Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Row Number in DAX

Hi, My SQL query is this ;   SELECT              CommitteeName,             AllotmentMainID,             ApprovedTotalLimit,             ROW_NUMBER() OVER(PARTITION BY CommitteeName,AllotmentM...
Row Number in DAX
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you for your answer but I I could not tell sorry.

For Example : 

 

CommitteeNameAllotmentMainIDApprovedTotalLimit 
A1002500 
A1002500 
A1003000 
B2005000 
C30010000 
C3005000 

 

Result : 

CommitteeNameAllotmentMainIDApprovedTotalLimitRowNumber
A10030001
A10025002
A10025003
B20050001
C300100001
C30050002

 

I want to this.

 

Thank U:)

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

how do you want to break a tie-situations?

 

you can add an Index column in powe query and the create a dax rankx calculated column

Column = 
    RANKX(
        FILTER(
                'Table',
                'Table'[CommitteeName]=EARLIER('Table'[CommitteeName]) &&  'Table'[AllotmentMainID]=EARLIER('Table'[AllotmentMainID])
                ),
        'Table'[ApprovedTotalLimit] + [Index]/1000000, , DESC, Skip
        )