Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

weekly

Hello,

 

I'm trying to make a weekly report on stuff.

 

for example here per year.

 

Here per day.

 

 

Now I want also a weekly graph. Is this possible?

thank you

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , 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]