Forum Discussion

cozger's avatar
cozger
New Member
4 years ago

Days Sales Outstanding (DSO) Calculation

I have a view report running on oracle database. With this report, I see each day's transaction one by one, line by line. I want to prepare a monthly dso report using this report. The formula I use is my average receivables (opening customer balance+closing customer balance/2)/ total sales. As a result, I divide it into 360 days.

The problem I'm having is this. While doing this analysis on a monthly basis, I need to calculate based on the figures of the last 12 months, but the data I have is only one. For example, when calculating the average receivables for February, the balance of January should be taken into account.

Can you share if you have alternative solution suggestions so that I can calculate the average receivable period?

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    cozger , like excel we can not do C3 = C2+ B3
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

    we have to do calculations like

     

    example

    Inventory / OnHand
    [Intial Inventory] + CALCULATE(SUM(Table[Ordered]),filter(date,date[date] <=maxx(date,date[date]))) - CALCULATE(SUM(Table[Sold]),filter(date,date[date] <=maxx(date,date[date])))

     

    or


    Inventory / OnHand
    CALCULATE(firstnonblankvalue('Date'[Month]),sum(Table[Intial Inventory]),all('Date')) + CALCULATE(SUM(Table[Ordered]),filter(date,date[date] <=maxx(date,date[date]))) - CALCULATE(SUM(Table[Sold]),filter(date,date[date] <=maxx(date,date[date])))