Forum Discussion
Split months into full weeks
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!
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.
3 Replies
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.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 Thank you so much for your help.
It works perfectly 😊
