Calculate no.of days from two different dates

[vijay22kar]

Hi All,

How to Calculate no.of days from two different dates. (e.g 2019-07-13 and 2020-01-10) There is the year changed.

[v-gizhi-msft · Accepted solution]

Hi,

Please try to create three calculated columns:

Year difference = DATEDIFF('Table'[DateStart],'Table'[DateEnd],YEAR)

Month difference = DATEDIFF('Table'[DateStart],'Table'[DateEnd],MONTH)

Day difference = DATEDIFF('Table'[DateStart],'Table'[DateEnd],DAY)

And the result shows:

Best Regards,

Giotto Zhi

[amitchandak]

datediff(date1,date2,days)

[Gordonlilj]

Hi,

Try using DATEDIFF

Column = DATEDIFF('Table'[Startdate],'Table'[Enddate],DAY)

[vijay22kar]

I tried it but shown only difference from the days but there is a year and the month is different.

[amitchandak]

datediff(date1,date2,month)