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
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
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?