Total dates between a set of dates.

[stites_adam]

Hi, 

I am looking on how to get this to give me the total of the diff from the first date and the last date- 

I need the total from 1/4 to 2/17- 44 days not 4 days.

[PhilipTreacy]

Hi @stites_adam 

Please @ mention me in replies or I will not see them.  Type @ then select my name.

Can you please provide your PBIX or your data?

Regards

Phil

[stites_adam]

@PhilipTreacy It may be the index that was added, I do not have that. Sorry, I am new at this all. I will try to upload my PBIX.

[PhilipTreacy]

@stites_adam 

No worries.

Upload the PBIX to OneDrive or DropBox then link to it here.

Phil

[stites_adam]

@PhilipTreacy - This formula did work! Sorry for the delay on getting back to you. 

[PhilipTreacy · Accepted solution]

Hi @stites_adam 

Download example PBIX with data and code

This works for me

TotalDays = DATEDIFF( FIRSTDATE('Detail'[Actual Start Date]), LASTDATE('Detail'[Actual Finish Date]),DAY)

Regards

Phil

[stites_adam]

Oddly, I still get 4 as the total-