Invoice Oustanding days formula

[homboy27]

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

[v-dineshya]

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 · Accepted solution]

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]

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.

[Greg_Deckler]

@homboy27 Try:

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