Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Gattinomio
Frequent Visitor

Split months into full weeks

Hello,

 

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

 

Gattinomio_0-1690548926059.png

 

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!

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

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

Screenshot_1.png

 


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.

View solution in original post

3 REPLIES 3
Gattinomio
Frequent Visitor

@Ahmedx Thank you so much for your help.

It works perfectly 😊

Ahmedx
Super User
Super User

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
Super User
Super User

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

Screenshot_1.png

 


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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.