Forum Discussion

avi081265's avatar
avi081265
Icon for Helper III rankHelper III
3 years ago
Solved

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 ...
Need Help
avi081265's avatar
avi081265
Icon for Helper III rankHelper III
3 years ago

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 NoStatusTO Be Approved DateApproval DateDeploy DateOffline DateDaysFormula
ABCD002Approved4/21/20236/12/2023  52Approval-To Be approved
ABCD0021Approved5/21/20235/25/2023  4Approval-To Be approved
ABCD0031Approved5/21/20235/29/2023  8Approval-To Be approved
ABCD0032Approved4/21/20239/12/2023  144Approval-To Be approved
ABCD003Deploy3/3/20235/5/20236/1/2023 27Deploy-Approve Date
ABCD004Deploy3/3/20235/5/20236/20/2023 46Deploy-Approve Date
ABCD007Offiline4/21/20236/12/2023 7/1/202311Offline - Approval Date
ABCD008Offline4/2/20235/3/2023 7/12/202370Offline - Approval Date
ABCD009Offline4/2/20235/3/2023 7/12/202370Offline - Approval Date
ABCD009Offline4/2/20235/3/2023 9/12/2023132Offline - Approval Date

Avi

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

avi081265

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

  • avi081265's avatar
    avi081265
    Icon for Helper III rankHelper III
    3 years ago

    Hello

     

    I try to share Onedrive url, not able to share it, so I senr email to you.

     

    I also added Sample file with some test account. in next thred.

     

    Avian

      • Ritaf1983's avatar
        Ritaf1983
        Icon for Super User rankSuper User
        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.

        Link to a sample file with solution 

        If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly