To calculate relative week-numbers

[msb007]

Need help from experts. I tried a million ways but its not working.

I am trying to create relative week-numbers for 52 rolling weeks. The current week should be week-number "1" and backwards.

Attached image may explain it better.

[apathetichell · Accepted solution]

floor(DATETIMEDIFF(DATETIMETODAY(),[date1],"days")/7)

datetimetoday() should be your max date which you get from summarize and append.

[date1] is the date of your week which you are looking to compare.