Forum Discussion

smedina1's avatar
smedina1
Frequent Visitor
3 years ago
Solved

RANKX

Hi Everyone,  I have a question about a project with a data. Here we have a column "Order Number"  where there are several numbers, that some of them are repeated, we want to formulate in DAX, th...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi smedina1 ,

     

    Please try adding an index column in the PowerQuery Editor and then a new calculated column in the desktop.

    State = 
CALCULATE (
    COUNT ( 'Table'[Index] ),
    'Table'[Order Number] = EARLIER ( 'Table'[Order Number] )
        && 'Table'[Index] <= EARLIER ( 'Table'[Index] )
)

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi smedina1 ,

 

Please try adding an index column in the PowerQuery Editor and then a new calculated column in the desktop.

State = 
CALCULATE (
    COUNT ( 'Table'[Index] ),
    'Table'[Order Number] = EARLIER ( 'Table'[Order Number] )
        && 'Table'[Index] <= EARLIER ( 'Table'[Index] )
)

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data