Forum Discussion
Solved
DATEDIFF Incorrect Conversion Output
The DATEDIFF calucation is outputting incorrect values as can be seen in the screen capture below. Is there a specific reason why that anyone is aware of, or is there a more accurate method to get t...
I've only got working results also.
See updated PBIX attached. Page 2.
The first place I'd be looking is the data types for the dates and see if there are any conversion issues/locale issues, but I doubt that is going to account for such significant differences.
Add custom column:
= Duration.Days([DecommissionDate]-[DateFirstUse]))
Power BI doesn't like calculated date columns with a SQL datasource. Adding a custom column in Power Query produces correct calculations for all values.
The results for the above function can be seen in the screen capture below that are subtsantially higher -
