Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Need Help: Customer DSO

I am creating a Account Recebable Dashboard. I finding difficulty in creating Customer DSO in Power BI. I need to show Customer DSO, customer wise for last 12 monthm month wise for a year. For Custo...
Need Help
vinaypugalia's avatar
vinaypugalia
Resolver I
6 years ago

Hello Anonymous ,

 

As per my understanding, DSO can be calculated by dividing the amount of Accounts Receivable/Sundry Debtors as on the given period by the total value of credit sales during the same period, and multiplying the result by the number of days in the period measured.

 

Hope, this helps!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello  vinaypugalia,

    Thank you for reply. Your formula is same, what I have asked for. But could you please create formula to show report month wise. Because I could not able to  create formula for the same.