Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vijay22kar
Helper II
Helper II

Calculate no.of days from two different dates

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.

 

1 ACCEPTED SOLUTION
v-gizhi-msft
Community Support
Community Support

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:

11.PNG

 

Best Regards,

Giotto Zhi

View solution in original post

5 REPLIES 5
v-gizhi-msft
Community Support
Community Support

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:

11.PNG

 

Best Regards,

Giotto Zhi

amitchandak
Super User
Super User

datediff(date1,date2,days)

Gordonlilj
Solution Sage
Solution Sage

Hi,

 

Try using DATEDIFF

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

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

 

datediff(date1,date2,month)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.