Forum Discussion

Balaraju's avatar
Balaraju
Icon for Helper III rankHelper III
2 years ago
Solved

Serial Number based on the Alphabetical order

Hi Everyone, I have a scenario, I have multiple countries each country having multiple States. I need to create serial number column for states in each country. attaching sample data below. Co...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Balaraju 

    you can try this to create a column

     

    Serial No = rankx(FILTER('Table','Table'[Country]=EARLIER('Table'[Country])),'Table'[States],,ASC)
     
     
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

Balaraju 

you can try this to create a column

 

Serial No = rankx(FILTER('Table','Table'[Country]=EARLIER('Table'[Country])),'Table'[States],,ASC)