Create Column with modification of one condition

Question

Hi,&nbsp;I have a dataset with the following&nbsp;TIme FrameLatest 4 wks - 02/06/2021Latest 13 wks - 02/06/2021Latest 26 wks - 02/06/2021Latest 52 wks - 02/06/2021&nbsp;I am using a create column function to give me the "Time Frame", either 4,13,26 or 52 and it is working good.&nbsp;However because my formula to capture this = Trim(Left(Time Frame,12) gives me the correct results of:&nbsp;Latest 13wksLatest 26wksLatest 4 wksLatest 52wks&nbsp;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:&nbsp;Latest 04 wksLatest 13wksLatest 26wksLatest 52wks&nbsp;How can I accomplish this?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

tahreem24 · Accepted Answer

Anonymous&nbsp;,
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)

&nbsp;
Final Output:

&nbsp;

Forum Discussion

Create Column with modification of one condition

2 Replies

Related content

Modification of Warehouse & Deployment Pipeline structure: Drop & Create table ????

Fetch the File modification time

Create conditional measure

Create conditional index column

Rank with conditions