Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorting Problem with million format

Hi everyone, I am new here and have a problem with sorting a table. I created a Measure to format the numbers in million. For example if I have 1.000.000 it should show 1m. I made this with this mea...
Need Help
danextian's avatar
danextian
Super User
6 years ago

Hi Anonymous,

 

As what FrankAT mentioned, FORMAT function returns a string so your millions are not sorted by the number value but alphabetically.  You may follow what he suggested.