Need Help: Customer DSO

[Anonymous]

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 Customer DSO formula : = ((Amount Received Current Month)-Total Sales))/No of days.

How I should find monthly received amount and Number of days month wise to craete this formula.

So, for Example If I selecte Customer ABC, I could able to see the DSO from JAN'19 till current Month. Could you please help me in this?

Report should look like this

Customer Name               Jan'19        Feb'19         Mar'19 

ABC                                   80               79                   81  and so on till Dec'19.

Please help me to create this formula.

[vinaypugalia]

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]

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.