Descending order column and recent to 13 weeks back

[Anonymous]

I wanted to know how to make my columns in descending order so it show weeks running back up to 13 weeks

[amitchandak · Accepted solution]

@Anonymous , Create columns like

BIWEEK 1  = [BIWEEK]

BIWeek Sort = rankx(Table, [BIWEEK],,desc,dense)

Then sort BIWEEK 1 on BIWeek Sort and use BIWEEK 1 in visual

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[Anonymous]

That worked like a carm  thanks.. Do you know how I can have it so it goes back 13weeks from today ?