Sort Table Data by Week

[Anonymous]

Hi Team,

I have a table with regular dates a data has been recorded. However I want them to show as weeks similar to what you're seeing in the screenshot below:

Let me know if this is possible or not.

Thanks!

[v-robertq-msft]

Hi, @Anonymous 

If you want to change it to become that Sunday will be the start of the week, you can change the second parameter of the WEEKDAY() function to 1, it will make Sunday become the start of the week in your calendar table, like this:

And you can get what you want.

You can download my test pbix file here

More info about the WEEKDAY() function in DAX

Best Regards,

Community Support Team _Robert Qin

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

[amitchandak · Accepted solution]

@Anonymous , Removed, Added and Difference is a column in table?

You can create new columns like in date table format the way you need

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1 //,2 means Monday week
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)

[Anonymous]

This worked! 

Follow-up question, how do I change it that Sunday will be the start of week?