Forum Discussion

homboy27's avatar
homboy27
Icon for Helper III rankHelper III
1 year ago
Solved

Invoice Oustanding days formula

Please see below. I am trying to do formula for days outstanding for invoice but it keeps giving me 92 days. What formula do I do to give me 23 days.    Invoice # Invoice Amount Date Invoiced ...
Need Help
Show and Tell
Tips and Tricks
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    Hi homboy27 ,

    We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

     

    Regards,

    Dinesh

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
1 year ago

Hi,

Assuming Days outstanding is a column in your data table, drag this measure to a card visual

Avg = average(Data[Days outstanding])

Hope this helps.