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 ma...
Need Help
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.