Calculate Days Between Dates Based on Field's Value

[Tcoher22]

I'm a novice with PowerBI and could use some help attempting to calculate the days between dates based on different columns. 

From this table: 

If Invoice 2 Amount populated, I want to subtract the Invoice Date associated with Invoice 1 Amount from Invoice 2. And so on for the other invoices. Trying to get a sense of what the aging of invoices looks like at different phases of our billing cycle. 

Any help would be greatly appreciated!

Thanks in advance!

[Anonymous]

It's help you?

Measure := ALCULATE ( SUM ( Table[INVOICE1] ) + SUM ( Table[INVOICE2] ) + SUM ( Table[INVOICE3] ) ; DATESBETWEEN ( Date ; MIN ( Date [Date] ) ; MAX ( Date[Date] ) )

[Tcoher22]

Unfortunately, no. What I'm attempting to do is pull the date value when the column for invoice 2 is populated and then subtract the invoice date associated with Invoice 1 from it. 

For example: 

For invoice 2 the Invoice date is 4/2/19. I want to subtract 2/6/19 from that date to return the value 55 days. 

My goal is to measure the time spent between invoices. 

Does that make sense?

Thanks again!