Forum Discussion

gianmarco's avatar
gianmarco
Icon for Helper IV rankHelper IV
4 years ago
Solved

How to filter CALENDARAUTO()

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?

 

Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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.

2 Replies

  • SpartaBI's avatar
    SpartaBI
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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 

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    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.