FILTERING A DATE TABLE BASED ON MIN AND MAX VALUES

[Michaelbean21]

I am trying to create a filtered date table based on min and max values which are set to data type "Date/Time".

However I am getting an error telling me that "an invalid numeric representation of a date value was encountered". 
But my "Date" in my Complete Date table is also set to data type "Date/Time".

So I have no values to my knowledge that are not data type "Date/Time".

Does anyone know why this happenning?

[v-zhangti]

Hi, @Michaelbean21 

You can try the following method to create a date table using the maximum and minimum values.

Date = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

Best practices recommend splitting DateTime values into two separate dimension tables: one for Date; the other for time.
DATESBETWEEN also requires date expression for the parameters: