Forum Discussion
Sort by Columns
Hello guys, I created a calculated column which helped me to categorize the tenure of my employees. The results are the following 0-30 days 31-60 days 61-90 days 91-180 days 181- 365...
Anonymous
Try changing them to this.
Tenure = VAR _Days = TODAY () - Agents[Production Date].[Date] RETURN SWITCH ( TRUE (), _Days <= 30, "0-30 Days", _Days <= 60, "31-60 Days", _Days <= 90, "61-90 Days", _Days <= 180, "91-180 Days", _Days <= 365, "181-365 Days", "+365 Days" )Tenure ID = VAR _Days = TODAY () - Agents[Production Date].[Date] RETURN SWITCH ( TRUE (), _Days <= 30, 1, _Days <= 60, 2, _Days <= 90, 3, _Days <= 180, 4, _Days <= 365, 5, 6 )
Hello Anonymous
When you created your [Tenure ID] column you say you used the [Tenure Category] (your first calculated column) yes?
Can you share the two DAX formulas you used to make the columns?
I created a sample table and made my category and two sort columns. On the first sort column I used the category, on the second I replicated the category logic to get the sort.
Because my first sort field looks at the category field I cannot sort the category field using it. I am basically telling it to sort category by category.
If I sort category by the second sort, the one that does not look at the category field but instead uses the same logic as the category field to determine the sort value it works fine.