column based on weeks

[Anonymous]

Hello everyone, 

I have a date column in my data source which contains information about Year, Month, Quarter and Day. 

I want to build a column chart which the axis is as shown in the picture below. Can anyone tell me how can I create such an axis?

[Seth_C_Bauer]

@Anonymous You can create a calculated column. -> 

MonthDay = FORMAT([Date],"MMMM dd")

[Anonymous]

@Seth_C_Bauer 

Thank you for your reply. I used the formula you mentioned, but what I receive is shown in the picture. It is showing every day of the month, but what I want is that the width of the column to be 7 days, as shown in the picture in the post. 

[Seth_C_Bauer · Accepted solution]

@Anonymous  

Weekend = 'Date'[Date]-MOD('Date'[Date]-1,7)+5

This gives you a week ending on Friday, adjusting the above inputs would provide you what you need.

[Anonymous]

My final formula looks like this:

MonthDay = FORMAT('Date'[Date]-MOD('Date'[Date]-1,7)+5,"MMMM dd")

and for now, it works perfectly 🙂

Thank you @Seth_C_Bauer