Forum Discussion
Helper ITOTALMTD date parameter is causing incorrect results
Super UserMattRasmussen , The date you are joining with the date of date tbale , is having a timestamp. Means time other than 12 AM.
You need create a date first
Date new = datevalue([Date])
Refer video and blog Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI
:https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
- MattRasmussen
Thank you for looking at my issue, amitchandak. I watched your video to understand what you mean but our calendar table has no timestamp:
However, the Week Ending Date column of the employee hours worked table is a data type of Date (not Date/Time) and it has no time in the column. I cannot select a format with a time for the column. Just to clarify, here is the join between the calendar and the employee hours worked table, note that the Week Ending Date column does not have the calendar icon next to the name like the calendar_date column:
Does the data type of Week Ending Date affect the time intelligence functionss? Any other ideas why these functions do not work for me?
