Forum Discussion
Sort by calculated column
Hi Power BI Community! I have this calculated column: Target Data HQ = var _diff = TrackET[Aver. Note to delivery h] return Switch ( True() , _diff <= 42, " < 42 h" , _diff <= 48, " <...
Recreate your calculated column as another column but instead of having the expected value you want in your SWITCH, you just put integers 1 to 5. See formula below.
Target Data HQ =
var _diff = TrackET[Aver. Note to delivery h]
return
Switch ( True() ,
_diff <= 42, 1 ,
_diff <= 48, 2,
_diff <= 72, 3,
_diff <= 96, 4,
_diff <= 196, 5,
6
)
After creating this new column, you can now apply Sort by Columns to your original calculated column
After creating this new column, you can now apply Sort by Columns to your original calculated column