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 we...
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
Ritaf1983
Super User
Super UserHI 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