Forum Discussion
weekly
Hi Anonymous ,
You will need to create a calculated column to get the week number for the date then you could use this week column as x-axis.
https://docs.microsoft.com/en-us/dax/weeknum-function-dax .
Best Regards,
Jay
Super UserAnonymous , i doubt the default date hierarchy has that. We usually add week year, year week column in date table and use it
Week start or end date is another option for axis
example
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)
Week Number = WEEKNUM([Date],2)
Week = if('Date'[Week Number]<10,'Date'[Year]*10 & 'Date'[Week Number],'Date'[Year]&'Date'[Week Number])
Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
Week name = [Week Start date] & " to "& [Week End date]