Forum Discussion

eszter_bn's avatar
eszter_bn
New Member
1 year ago
Solved

Weekly view in chronological order

Hi,   I need to build a report where I show rolling 3m performance by week - I created a column that shows start of the week, and a week and year column (format YYYYWW) to sort my weeks by, but whe...
Need Help
  • speedramps's avatar
    speedramps
    1 year ago

    Download my example PBIX solution from Onedrive
    Click here 

    We are unpaid volunteers and you have got free expert help which took a lot of effort.
    This solution works and does exactly what you asked.
    So please quickly click the [accept as solution] and the thumbs up button to leave kudos.

    Please try refrain from expanding this question.
    If you need to change or extend your request then please raise a new ticket.
    One question per ticket please !
    You will get a quicker response and each volunteer solver will get the kudos they deserve.

    If you quote speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.
    However I will respectfully decline to help members who initially ask misleading or incomplete questions and then wont accept the correct soltion. Hope you apprecaite why.

    Please now click the [accept as solution] and the thumbs up button. Thank you

AlexisOlson's avatar
AlexisOlson
Super User
1 year ago
I created a column that shows start of the week

What do the values in this column look like?

eszter_bn's avatar
eszter_bn
New Member
1 year ago

So it's the 'Week' colum that has the start of each week (this I created in Power Query using Date.StartofWeek using a transactional date column). This is in a text format but I tried to convert it to date, I get the same error message. I tried to use the Week-Year Sort column to sort the week column by, this is whole numbers.