Forum Discussion
Aging Analysis for different day range
Hello All,
I have Order table, I want generate to generate aging analysis. Order table has following fields
1. Order No.
2. Order creation Date
3. To be Approval Date
4. Approval Date
5. To be Deploy Date
6. To be Offline Date
I have created following measure and calculating days, which are working correctlu
ToApprove = Approval Date - To be Approval Date
ToDeploy = Approval Date - To be Deploy Date
ToOffline = Approval Date - To be Offline Date
Now I want to generate in following format. In following table I want to show the numbers of the orders for each measure in different range.
Please let me know how can I achieve this kind of report.
Regards
Avian
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
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
12 Replies
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
- Hello Ritaf1983, I already saw this url. If you compare url you provided and my requirement, both are two different requirement. If any sample which is just like my requirement, it will be very useful for me. Avian
