Forum Discussion

ThomasSan's avatar
ThomasSan
Icon for Helper IV rankHelper IV
4 years ago
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...
DATEDIFF
Time Intelligence
  • johnt75's avatar
    johnt75
    4 years ago

    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

ThomasSan's avatar
ThomasSan
Icon for Helper IV rankHelper IV
4 years ago

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?

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

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