How to count amount of days between 2 dates

[Anonymous]

Hey all,

I have a table like this

Date occured	Date Reported
1/1/20	2/1/20
3/2/20	3/2/20
5/7/20	15/7/20

How would I write DAX to count the days from occured to reported and then provide the average. Also counting same day reported as "1" not "0".

Thanks,

J

[amitchandak]

@Anonymous , You can create a new column like

New column =datediff([Date occured],[Date Reported],Day)+1

And take Average of this

[Anonymous]

@amitchandak 

Thanks that worked great! Is there a way to also count only Mon - Fri?

J

[amitchandak · Accepted solution]

@Anonymous , Check this file, on 2nd page there is visual having working day diff

https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0

Just make sure weekday is taken correctly