Forum Discussion
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 B...
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.