Manually Sort Columns?

[f4gfm0]

Is there a way to manually sort columns when first day of week starts on a Sat for our organization?

I'm getting the following result but not sure how to achieve the days starting on Sat and in order from there?

[Anonymous · Accepted solution]

Hi  @f4gfm0 ,

I created some data:

Here are the steps you can follow：

1. Create calculated column.

WEEK = FORMAT('Table'[Date],"ddd")

2. Create a table using Enter data.

3. Connect the relationship between the two tables.

4. [Week] – Column tools– Sort by column  – [Index].

5. Result:

Best Regards,

Liu Yang

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

[Fowmy]

@f4gfm0 

Create a sort column in your table as follows with the paramter 16 and sort your Weekday Column using this sort column

Weekday Sort = WEEKDAY('Dates'[Date],16)