Forum Discussion

slc7456's avatar
slc7456
Icon for Advocate III rankAdvocate III
9 years ago
Solved

Format DAX function does not sort properly

Data Source: Tabular Cube    Purpose: Create a new measure that is a whole number formatted as currency, i.e. no decimals. This new measure must be able to sort high to low.    Background: Micros...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Ya, I think you are hosed until the June release.  As soon as you use FORMAT( ) your measure it going to return text, and that will cause text based sorting... and not much you can do about that (outside of... don't use FORMAT, but then you hit the other bug w/ built in formatting not saving).

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Ya, I think you are hosed until the June release.  As soon as you use FORMAT( ) your measure it going to return text, and that will cause text based sorting... and not much you can do about that (outside of... don't use FORMAT, but then you hit the other bug w/ built in formatting not saving).

  • slc7456's avatar
    slc7456
    Icon for Advocate III rankAdvocate III
    9 years ago
    I think you're correct. I'll try again in june. Thanks!
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi, 

       

      Was this fixed?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Scottsen!

     

    Do you know, if this issue was resolved? I'm having the same problem. 

     

    I can't see any fix mentioned on the june-2017 update list.

     

    Br, Torben

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    does anyone know if its resolved? FORMAT() is still doign Text sorting