undefined

[Anonymous]

Hi,

I have a custom column created & it is the below:

=if(YEAR(Task[UpdatedDate])<>1970,SWITCH (
TRUE (),
Task[UpdateAge_Days] <1 , "<1 Day",
AND(Task[UpdateAge_Days] <=2 ,Task[UpdateAge_Days] >=1),"1-2 Days",
AND(Task[UpdateAge_Days] <=3 ,Task[UpdateAge_Days] >2),"3 Days",
AND(Task[UpdateAge_Days] <=5 ,Task[UpdateAge_Days] >3),"4-5 Days",
AND(Task[UpdateAge_Days] <=10 ,Task[UpdateAge_Days] >5),"5-10 Days",

Task[UpdateAge_Days] >10 ,">10 Days "
))

I want to sort as per above,but it shows the below:

<1day

>10days

1-2days

3days

4-5days

5-10days

I want it to be like this:

<1day

1-2days

3days

4-5days

5-10days

>10days

Please help in sorting the above

[Anonymous · Accepted solution]

@amitchandak @onurbmiguel_ @lbendlin  & other who are seeing

Please help

[lbendlin · Accepted solution]

Read about "Sort a column by another column".

Your code can be cleaned up:

=SWITCH (
TRUE (),
YEAR(Task[UpdatedDate])=1970,BLANK()
Task[UpdateAge_Days] <1 ,"<1 Day",
Task[UpdateAge_Days] <=2,"1-2 Days",
Task[UpdateAge_Days] <=3,"3 Days",
Task[UpdateAge_Days] <=5,"4-5 Days",
Task[UpdateAge_Days] <=10,"5-10 Days",
">10 Days "
)

[onurbmiguel_ · Accepted solution]

hi @Anonymous 

You need to creat two columns 

• the first one , as @lbendlin  have write  , with the efective label that you want: 

Label =
SWITCH (
TRUE (),
YEAR(Task[UpdatedDate])=1970,BLANK(),
Task[UpdateAge_Days] <1 ,"<1 Day",
Task[UpdateAge_Days] <=2,"1-2 Days",
Task[UpdateAge_Days] <=3,"3 Days",
Task[UpdateAge_Days] <=5,"4-5 Days",
Task[UpdateAge_Days] <=10,"5-10 Days",
">10 Days "
)

• and the ohther one for the sort: 

Label (sort) =
SWITCH (
TRUE (),
YEAR(Task[UpdatedDate])=1970, 99,
Task[UpdateAge_Days] <1 , 1,
Task[UpdateAge_Days] <=2, 2,
Task[UpdateAge_Days] <=3, 3,
Task[UpdateAge_Days] <=5, 4,
Task[UpdateAge_Days] <=10, 5,
6
)

like this you can use column "Label (sort)" to sort the first one. 

Any other question please ask. 

Best regards

Bruno Costa | Impactful Individual

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!

[Anonymous]

Thank you all for your help!

[Anonymous · Accepted solution]

@amitchandak @onurbmiguel_ @lbendlin  & other who are seeing

Please help

[onurbmiguel_ · Accepted solution]

hi @Anonymous 

You need to creat two columns 

• the first one , as @lbendlin  have write  , with the efective label that you want: 

Label =
SWITCH (
TRUE (),
YEAR(Task[UpdatedDate])=1970,BLANK(),
Task[UpdateAge_Days] <1 ,"<1 Day",
Task[UpdateAge_Days] <=2,"1-2 Days",
Task[UpdateAge_Days] <=3,"3 Days",
Task[UpdateAge_Days] <=5,"4-5 Days",
Task[UpdateAge_Days] <=10,"5-10 Days",
">10 Days "
)

• and the ohther one for the sort: 

Label (sort) =
SWITCH (
TRUE (),
YEAR(Task[UpdatedDate])=1970, 99,
Task[UpdateAge_Days] <1 , 1,
Task[UpdateAge_Days] <=2, 2,
Task[UpdateAge_Days] <=3, 3,
Task[UpdateAge_Days] <=5, 4,
Task[UpdateAge_Days] <=10, 5,
6
)

like this you can use column "Label (sort)" to sort the first one. 

Any other question please ask. 

Best regards

Bruno Costa | Impactful Individual

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!

[onurbmiguel_ · Accepted solution]

hi @Anonymous 

Does my suggestion work?
If yes then please accept my answer have solution thanks

Best regards

Bruno Costa | Impactful Individual

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!

[lbendlin · Accepted solution]

Read about "Sort a column by another column".

Your code can be cleaned up:

=SWITCH (
TRUE (),
YEAR(Task[UpdatedDate])=1970,BLANK()
Task[UpdateAge_Days] <1 ,"<1 Day",
Task[UpdateAge_Days] <=2,"1-2 Days",
Task[UpdateAge_Days] <=3,"3 Days",
Task[UpdateAge_Days] <=5,"4-5 Days",
Task[UpdateAge_Days] <=10,"5-10 Days",
">10 Days "
)