Average Collection Period

[Oros]

Hello.

I have a customer data on the following:

terms (for example; net 30 days)

sales ($)

current owing ($)

payment ($)

payment dates

What would be the best formula to use  in Power Bi to get the AVERAGE COLLECTION PERIOD (in days)?

Thanks

[amitchandak]

@Oros , I think we need two dates, Due date and collection dates

[Oros]

Hi @amitchandak ,

Thank you very much for your quick reply.

Here is a sample data from Business Central.  The customer is on 14 DAYS payment terms.  How do you calculate and show in Power Bi the average collection period (days) and average late payment (days).  These 2 fields seem to be a calculated field in Business Central and NOT saved in the database.  Thanks again.

[Oros]

Hi @amitchandak,

Did you get a chance?  Thanks.