Forum Discussion
Chronological Week Number Order in Matrix Over Multiple Years
Hello, I'm trying to get my "Week Num and Week Start Date" column in my Matrix Visual to order correctly from left to right(i.e...W52 12/22, W53 12/29, W2 01/05, W3 01/12, etc.). However, the chr...
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
How did you managed to add the Calendar Year to avobe the weeks on the matrix, I know is unrelated but it will solve my issue