Problem using DATEDIFF with date hierarchy

[Tabaqat_Team]

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.

[Arul · Accepted solution]

@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