Counting days of client has a debt

[D3K]

Hello everyone!

Faced with next situation and can't find a desicion. I've found a couple looks alike topics here, but it didn't work out in my case.

Will highly appreciate any help!

I have a historical table with client's debts.

And the main goal is to know for each client, how many days he has a new debt since he closed his previous one.

Like in example above for client #2:

- 01.01.2019 has a debt $120 for 31 days already

- 02.01.2019 he closed his debt and his debt became 0

- 03.01.2019 he got the new debt for $50 and it's the day #1 with new debt

And after it I want to make a visual, where I could see, how many days client has a debt for today.

Also here is the moment, at the same date client can have a several debts for different contracts, so we need to count cimulative debt at one date.

Hope I could to explain correct  and will find a solution here:) Thank you in advance!

[v-yuta-msft]

@D3K ,

---

And after it I want to make a visual, where I could see, how many days client has a debt for today.

Also here is the moment, at the same date client can have a several debts for different contracts, so we need to count cimulative debt at one date.

---

Could you clarify more logic about the expected result such as "debt for today"? 

Community Support Team _ Jimmy Tao

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

[D3K]

Hi @v-yuta-msft 

Thank you for attention to my question.

Yes, the visual is gonna be like this table:

Today is the 30th of April and at this moment our clients has a debts for the number of days

Client ID |  Client Name |  Days with debt

      1                xxxxx                31

      2                yyyyy                 2

and so on

"Days with debt" is that goal what I'm looking for - number of days since client had 0 (zero) debt

In other words, how many days in a row until today client has a debt more than zero since he had a zero debt.

Thank you