Forum Discussion
Present data by month by week (same week in two months)
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.
HI Anonymous
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
3 Replies
- Ritaf1983
Super User
Anonymous
I'm always happy to help 🙂
- Ritaf1983
HI Anonymous
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