The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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 "
)
hi @Anonymous
You need to creat two columns
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 "
)
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!
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
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!
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
Thank you all for your help!
hi @Anonymous
You need to creat two columns
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 "
)
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!
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
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!
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
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 "
)
User | Count |
---|---|
78 | |
73 | |
38 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |