Forum Discussion
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...
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).
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).
does anyone know if its resolved? FORMAT() is still doign Text sorting