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
Hi johnt75 ,
thank you for your reply. When inserting DATEADD to my command, it returns the following table:
Here is the underlying table if that helps:
Do you happen to have an idea what is going wrong here?
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