Forum Discussion
Dynamic Week Number
I want to include the last 13 weeks of data in my charts from today's week. I first created a new column for Past13Weeks = IF(DATEDIFF([WEEKOF],TODAY(),DAY)<=91, 1, 0) but quickly realized that wo...
amitchandak The Week Rank is only giving me 1 for every row.
Week Rank = RANKX(all('Table1'[WEEKOF]),'Table1'[WKNM],,ASC,Dense) //YYYYWW format
dwel0120 , A new column
Week Rank = RANKX('Table1','Table1'[WKNM],,ASC,Dense) //YYYYWW format
prefer a separate week or date table
refer if needed