Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |