Forum Discussion
Aging Analysis for different day range
- 3 years ago
Hi avi081265
You can add your calculations as calculated columns and then create simple bins for them.
please refer linked tutorial:
https://www.youtube.com/watch?v=PjHgi7X3_BwIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- 3 years ago
Hi Avian65 .
This is the steps of a simple segmentation :
1. Add a column with Dax like :Time of execution = switch (true(),[Days]>=0 && [Days]<=30 , "0-30",[Days]>=31 && [Days]<=60 , "31-60",[Days]>=61 && [Days]<=90 , "61-90",[Days]>=91 && [Days]<=120 , "91-120",[Days]>=121 ,"121+")2. Add a column for the sort order of your time execution on the visuals:
rank to sort = switch (true(),[Days]>=0 && [Days]<=30 ,1,[Days]>=31 && [Days]<=60 , 2,[Days]>=61 && [Days]<=90 , 3,[Days]>=91 && [Days]<=120 , 4,[Days]>=121 ,5)3. Modify sort order:
4. Put all you need on a matrix:
Please Note :
There were some mistakes in your data, and I did not correct them.
Just wanted to show you how it works.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi avi081265 the content of url is only a part of segmentation.
Please provide some sample data and i will show you how you can get yours desired table.
Hello
Can you share your email address, I will send sample data excel. Sorry I dont know how to attach excel file in this message.
| Order No | Status | TO Be Approved Date | Approval Date | Deploy Date | Offline Date | Days | Formula |
| ABCD002 | Approved | 4/21/2023 | 6/12/2023 | 52 | Approval-To Be approved | ||
| ABCD0021 | Approved | 5/21/2023 | 5/25/2023 | 4 | Approval-To Be approved | ||
| ABCD0031 | Approved | 5/21/2023 | 5/29/2023 | 8 | Approval-To Be approved | ||
| ABCD0032 | Approved | 4/21/2023 | 9/12/2023 | 144 | Approval-To Be approved | ||
| ABCD003 | Deploy | 3/3/2023 | 5/5/2023 | 6/1/2023 | 27 | Deploy-Approve Date | |
| ABCD004 | Deploy | 3/3/2023 | 5/5/2023 | 6/20/2023 | 46 | Deploy-Approve Date | |
| ABCD007 | Offiline | 4/21/2023 | 6/12/2023 | 7/1/2023 | 11 | Offline - Approval Date | |
| ABCD008 | Offline | 4/2/2023 | 5/3/2023 | 7/12/2023 | 70 | Offline - Approval Date | |
| ABCD009 | Offline | 4/2/2023 | 5/3/2023 | 7/12/2023 | 70 | Offline - Approval Date | |
| ABCD009 | Offline | 4/2/2023 | 5/3/2023 | 9/12/2023 | 132 | Offline - Approval Date |
Avi
- Ritaf19833 years agoSuper User
Save it on onedrive and just share the link.
My mail is [email protected]
But i highly recommend to share it here. This will give you opportunity to see more suggestions to solution