Forum Discussion

Tabaqat_Team's avatar
Tabaqat_Team
Frequent Visitor
3 years ago
Solved

Problem using DATEDIFF with date hierarchy

I have a calculated column with the name 'Date' that represents date hierarchy and I want to calculate the months between today's date and this column in months when I use the following DAX:   = DA...
Need Help
  • Arul's avatar
    Arul
    3 years ago

    Tabaqat_Team ,

    Can you check the datatype of airbnb[Date] column? If it is not in date format then that is the reason for this error.

    You have to convert that column to date datatype.

    Thanks,

    Arul

Arul's avatar
Arul
Super User
3 years ago

Tabaqat_Team ,

Can you check the datatype of airbnb[Date] column? If it is not in date format then that is the reason for this error.

You have to convert that column to date datatype.

Thanks,

Arul