Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Generate a calendar without week-ends

Hey community,


Needed that, it's not complicated, just sharing if someone needs it :

a_calendrier = 
    VAR _mon_calendrier_ = CALENDAR(MIN(t_journee[jou_date]);MAX(t_journee[jou_date]))

RETURN
    FILTER(
        _mon_calendrier_
        ; WEEKDAY([Date];2) <> 6 && WEEKDAY([Date];2) <> 7
    )

 

Show and Tell
Tips and Tricks
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous 

    Thank you for your sharing! Please kindly mark helpful replies as answers. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous 

    Thank you for your sharing! Please kindly mark helpful replies as answers. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.