Forum Discussion
Helper IIIInvoice 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 | Date Paid | Days Oustanding |
| 123456 | 100,000 | 1/1/2025 | 1/24/2025 | 23 |
| 123456 | 100,000 | 1/1/2025 | 1/24/2025 | 23 |
| 123456 | 100,000 | 1/1/2025 | 1/24/2025 | 23 |
| 123456 | 100,000 | 1/1/2025 | 1/24/2025 | 23 |
| 92 |
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
4 Replies
- Greg_Deckler
Community Champion
homboy27 Try:
Days Outstanding Measure = VAR __Min = MIN( 'Table'[Date Invoice] ) VAR __Max = MIN( 'Table'[Date Paid] ) VAR __Result = ( __Max - __Min ) * 1. RETURN __Result - Ashish_Mathur
Super User
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.
v-dineshyaCommunity Support
Hi homboy27 ,
Thank you for reaching out to the Microsoft Community Forum.
Please refer below output snap and attached PBIX file.
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
- v-dineshya
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
