Forum Discussion

gy_1982's avatar
gy_1982
Frequent Visitor
3 years ago

Dateinperiod issue

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.

 

 

1 Reply

  • WinterMist's avatar
    WinterMist
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    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