https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/datesbetween-function-error/m-p/718065#M1287 <P>Get a Date table in your model.</P><P>All the Time Intelligence functions of DAX work better with a date table</P> Tue, 18 Jun 2019 18:06:04 GMT HotChilli 2019-06-18T18:06:04Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/datesbetween-function-error/m-p/718029#M1284 <P>i get the error:</P><P>&nbsp;</P><P>"a date column containing duplicate dates was specified...this is not supported"</P><P>(this is true that my date column has duplicate dates - it's an order file that can have many orders on the same day)</P><P>&nbsp;</P><P>???</P><P>&nbsp;</P><P>thank you.</P> Tue, 18 Jun 2019 17:22:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/datesbetween-function-error/m-p/718029#M1284 c-mschukas 2019-06-18T17:22:25Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/datesbetween-function-error/m-p/718065#M1287 <P>Get a Date table in your model.</P><P>All the Time Intelligence functions of DAX work better with a date table</P> Tue, 18 Jun 2019 18:06:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/datesbetween-function-error/m-p/718065#M1287 HotChilli 2019-06-18T18:06:04Z