Forum Discussion

jharanedac's avatar
jharanedac
Frequent Visitor
3 years ago

Amount variation between dynamics dates

Hi guys, I hope you are doing well. I'm new in Power BI and I need some help. I have a dataset where I updated it from a file that I got daily. The data has the debtor number and the debtor number may variate every day, where the person can move between different ranges, the amount might change,

e.g.:

Debtor 12345, Sept1, 1_30_Days, $100

Debtor 12345, Sept6, 31_60_Days, $200

The debtor move from 1_30 to 31_60 and now the amount changed as well.

I would to calculate the variation between dates, but the dates are not always continued like 1, 2, 3, 4, so the dates are more like dynamics 1, 3, 5, 6, 7, 10.

 

I created this table where I count debtors daily and another similar table with the amount daily.

 

I hope you can give me a hand on this. Thanks.

 

Need Help

2 Replies

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Community Support
    3 years ago

    Hi jharanedac ,

     

    Can you share with me some screenshots of your data after hiding sensitive information and tell me what's your expected output?

     

    Best regards,

    Yadong Fang

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

    • jharanedac's avatar
      jharanedac
      Frequent Visitor
      3 years ago

      Hi, thanks for your reply. This is how my data looks like. Where the customer is repetead for each day, the column "MAX AR AGE" might change between different ranges depending on how many days they have a debt. Same with "TOTAL_AR", this number might change as well.

       

      Raw Data:

      And this is what I would like to see where I'm substracting 2022-09-02 with 2022-09-01 to see how many debtors move from one to another range, same with 2022-09-06  minus 2022-09-02.

      Expected result:

       

       

      This is the table that is counting how many debtors by day, so the table above just substract the last day with the day before (Sep 02 - Sep 1, Sept 6 - Sep 2). I made it in excel because it was easy to show it.

       

      Original counting:

      Thanks again for your reply.