Forum Discussion
Chronological Week Number Order in Matrix Over Multiple Years
If you can use week year.
create a week's year. For that get week strat date as a new column and have week year as another
Week Start date = DATEADD('Date'[Date],-1*WEEKDAY('Date'[Date])+1,DAY) Week Year =year('Date'[Week Start date])Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
Super UserIf you can use week year.
create a week's year. For that get week strat date as a new column and have week year as another
Week Start date = DATEADD('Date'[Date],-1*WEEKDAY('Date'[Date])+1,DAY)
Week Year =year('Date'[Week Start date])
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
I haven't tried your recommendation yet but it sounds like it will get me the desired results but is there a way to leave out the Year from the Matrix Visual but still get the desired Week Number ordering?
I ended up using your strategy to determine the Year based on the Week Start Date. Then I added this Year column to my Matrix and got the desired results. If needed, I can always put a textbox over the Year portion of the Matrix to hide that data element from being seen by the users. Thanks!
IlMoroHelper II
Hi, I have the same situation however I did not understand what I have to do.
I have a date table in which there is the year, the week number and the start of the week date(date of each monday). How can I proceed now? I tried to sort the week number column for the star of week date but it does not work...