Generate a calendar without week-ends

[Anonymous]

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
    )

[dax · Accepted solution]

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.