Forum Discussion

Oros's avatar
Oros
Icon for Post Prodigy rankPost Prodigy
3 years ago

Average Collection Period

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

Need Help

3 Replies

    • Oros's avatar
      Oros
      Icon for Post Prodigy rankPost Prodigy
      3 years ago

      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.