Manually Sort Columns?

Question

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 Answer

Hi&nbsp; f4gfm0&nbsp;,
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 &nbsp;– [Index].

5. Result:

&nbsp;
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

Forum Discussion