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:

 

= DATEDIFF(airbnb[Date], TODAY(), MONTH)

 

It returns the following:

An invalid numeric representation of a date value was encountered.

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

1 Reply

  • 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