Split months into full weeks

[Gattinomio]

Hello,

I am looking for a way to avoid having calendar weeks split over two months like below.

If a week is split over two months, it should be considered as belonging to the month where it has 4 or more days.

Also it should be based on weeks starting Monday.

Any help to achieve this would be appreciated.

Thank you in advance!

[Gattinomio]

@Ahmedx Thank you so much for your help.

It works perfectly 😊

[Ahmedx]

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://1drv.ms/u/s!AiUZ0Ws7G26RiXOiUtZCxl3zl0Ep?e=4xFB3a

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.