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
az38's avatar
az38
Community Champion
6 years ago

Anonymous 

use rankx like

Column = 
    RANKX(
        FILTER(
                'Table',
                'Table'[CommitteeName]=EARLIER('Table'[CommitteeName]) &&  'Table'[AllotmentMainID]=EARLIER('Table'[AllotmentMainID])
                ),
        'Table'[ApprovedTotalLimit], , DESC
        )
sqldev2017's avatar
sqldev2017
Microsoft Employee
5 years ago

I think DAX is utter nonsense, compared to the simplicity of SQL !