Forum Discussion
Continuous Year Week on line chart
Hi, I have a date table in my model, where one column is a concatenation of the year and the week ( = [Year] & "-" & [WeekOfYear]). I want to use this column in the X-axis on my line chart. B...
Anonymous , you can try with the week start/end date. But that is another date.
Mon-Sun
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)
Sun-Sat
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date])+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date])
amitchandak Thank you I'll try it out!