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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
1 year ago

homboy27 Try:

Days Outstanding Measure = 
  VAR __Min = MIN( 'Table'[Date Invoice] )
  VAR __Max = MIN( 'Table'[Date Paid] )
  VAR __Result = ( __Max - __Min ) * 1.
RETURN
  __Result