Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Compare two strings alphabetically

Hello,   I have a list of activities id and subactivities id.  I want to create an index column for each activity so the table would look like this:   Activity id Sub-activity id Index A...
Need Help
  • FarhanAhmed's avatar
    FarhanAhmed
    4 years ago

    Does string comes with consistent value and Numbers at last ?

     

    You may want to split this column thru Power Query to sub activity and its number and then use the number column in the DAX expression.

NickolajJessen's avatar
NickolajJessen
Icon for Solution Sage rankSolution Sage
4 years ago

Here's an alternative soloution, should you ever need it.
Step 1: Make an index coloum in power Query that sorts in alphabetically (This could require a concatenation on Activity and activityid, if your data isn't already entered in the correct order)
Step 2: