How to filter CALENDARAUTO()

[gianmarco]

Dear All,

I have a CALENDARAUTO() table in my data model.

It automatically takes all the dates in my tables. But i would like to exclude some of those.

Is there a way I can filter this table to exclude some dates it automatically takes?

[v-jingzhang · Accepted solution]

Hi @gianmarco 

You can filter the table generated with CALENDARAUTO. For example,

But can you please give more details about which dates you want to exclude from it? 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[SpartaBI]

@gianmarco you mean whicu columna to consider? You can't. You can of courae put a filter on top of it to restrict the dates returned ans maybe you better use calendar function. You can share the model and tell me what you want to achieve and I'll send back the solution file