Create Column with modification of one condition

[Anonymous]

Hi,

I have a dataset with the following

TIme Frame

Latest 4 wks - 02/06/2021

Latest 13 wks - 02/06/2021

Latest 26 wks - 02/06/2021

Latest 52 wks - 02/06/2021

I am using a create column function to give me the "Time Frame", either 4,13,26 or 52 and it is working good.

However because my formula to capture this = Trim(Left(Time Frame,12) gives me the correct results of:

Latest 13wks

Latest 26wks

Latest 4 wks

Latest 52wks

But now I want to use the above as a slicer and I want them to appear as the following which is also in sorted order by time frame:

Latest 04 wks

Latest 13wks

Latest 26wks

Latest 52wks

How can I accomplish this?

[Tahreem24 · Accepted solution]

@Anonymous ,

Create new column as WeekNum like below:

WeekNum = WEEKNUM(Table[YourDateColumn])
Then go to Data view then select TimeFrame Column then click on "Sort by Column" then choose the above WeekNum column. (See the attached screen shot)

Final Output:

[amitchandak]

@Anonymous , I am assuming these are values in the column, Create a column that has sort order for these columns.

Refer my video, I have explained that in details:https://www.youtube.com/watch?v=KK1zu4MBb-c