Present data by month by week (same week in two months)

[Agne_J]

Hello, 

I have data that I need to present by month and then by week. My issue is that the same week appears in two months. Is there any solution to add one week only to one month (I.e., add a week to the month with more days in that week)?

I.e. in the image below, I would like the whole Week 39 to belong to September. 

[Agne_J]

@Ritaf1983 thank you! It worked!

[Ritaf1983]

@Agne_J 
I'm always happy to help 🙂

[Ritaf1983 · Accepted solution]

HI @Agne_J 

You can use this Formula in DAX to get the first date of the week besides all dates of the same week.

Startdate of week = [Date] + ((7- WEEKDAY([Date];2))-6)

Then use this to extract the month.

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