Forum Discussion
Solved
DATEDIFF only returning same value
Hi people, I am having the issue that my DATEDIFF returns the same value again (rather than the corresponding value from three months ago). The problem looks as follows: The dax command...
To work properly the time intelligence functions need a date table which contains all the dates for any given year. Create a date table and link it to your fact table, and then use the 'Date'[Date] column instead of the 'Table'[Date] column
Change DATEDIFF to DATEADD, everything else seems fine