Forum Discussion
Sort by calculated column
Impactful IndividualYou can't sort a calculated column, by the column it's derived from.
But you could make a second calculated column, and sort your original calculated column by that.
Target Data HQ Sort =
var _diff = TrackET[Aver. Note to delivery h]
return
Switch ( True() ,
_diff <= 42, 1 ,
_diff <= 48, 2 - Target Unscheduled Tool Down" ,
_diff <= 72, 3 ,
_diff <= 96, 4- Target Scheduled Tool Down",
_diff <= 196, 5- Target Tool up/Replenishment",
6
)
Then go to [Column Tools] > [Sort By Column] and sort your original calculated column, by that new column.
And probably hide that 'sort' column from your data model, so as to not confuse anyone.
mmace1 Thanks for the reply!
But I have this error because of the second calculated column:- mmace1
Is [Target Data HQ Sort] defined by [Target Data HQ]? Because you can't do that, or it'll throw the circular dependency error when you try to sort.
[Target Data HQ Sort] needs to be defined by a 3rd column that's justTrackET[Aver. Note to delivery h]
Example I just made locally: The Switch column is defined by Original, and the Swithc Sort Column is also defined by Original. Then I can sort the Switch Column, By Switch Sort Column, fine without an error.