topic Dateinperiod issue in DAX Commands and Tips

Dateinperiod issue

gy_1982 — Mon, 13 Mar 2023 13:39:51 GMT

Dear all ，

I would like to show the last 12 months in a slicer.

So, I am using datesinperiod() to create rolling 12 months dates .But I get the error message .

And ,Is the method suitable for this scenario?

Thanks.

Re: Dateinperiod issue

WinterMist — Mon, 13 Mar 2023 13:44:36 GMT

gy_1982

I believe for you to do this, you must use a date column with DISTINCT dates (no duplicates). Try using the date column from the 'Date' table instead.

Regards,

Nathan