Forum Discussion
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...
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.
FarhanAhmed
Community Champion
Community ChampionDoes 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.
Yes they all begin with the three same letters and then it's all numbers.
Thank you for the answer ! I can see that this will work.