Forum Discussion
Sort with DAX Function FORMAT
Hello All. Does anyone know when the bug will be fixed for sorting measure values that have the FORMAT() function applied to them?
Wait, what bug is that? FORMAT changes things to text. So if for some reason you are trying to sort something in numerical order that would be a problem. Not certain if that is a bug.
Thank you all for the responses.
I have a switch that goes bewteen Count and Sum.
when I format for currency it wont sort 😞
Switch (Customer Value) = SWITCH(MAX('(Switch) KPI'[ID]),1,[Switch (Count)],2,FORMAT([Customer (Total Sales)],"$#,##0.00"))