Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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
datediff(date1,date2,days)
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)
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |