datesbetween function error

[c-mschukas]

i get the error:

"a date column containing duplicate dates was specified...this is not supported"

(this is true that my date column has duplicate dates - it's an order file that can have many orders on the same day)

???

thank you.

[HotChilli]

Get a Date table in your model.

All the Time Intelligence functions of DAX work better with a date table