Forum Discussion
damit23183
Microsoft Employee
Microsoft EmployeeSorting on Start of Week not working
Hi, I have one Line and Stach chart created based on StartofWeek (DD/MM) and 2 measures. StartofWeek Dates are: 12/06,03/07,10/07,17/07.24/07,31/07 and so on Every Sunday. I am trying to ...
damit23183 , Hope you create two columns like
Week Start Date= [Date] - Weekday([Date],1) +1
Week = Format([Week Start Date], "dd/mm")
Then mark Week Start Date as a sort column of the week
How to Create Sort Columns and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
amitchandak
Super User
Super Userdamit23183 , Hope you create two columns like
Week Start Date= [Date] - Weekday([Date],1) +1
Week = Format([Week Start Date], "dd/mm")
Then mark Week Start Date as a sort column of the week
How to Create Sort Columns and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
damit23183Hi Amit,
Thanks it worked perfectly fine.
Thank you So much.