Forum Discussion
f4gfm0
4 years agoNew Member
Manually Sort Columns?
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 o...
- Anonymous4 years ago
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