cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Create Column with modification of one condition

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?

 

 

 

 

 

1 ACCEPTED SOLUTION
Tahreem24
Super User
Super User

@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)

Capture.PNG

 

Final Output:

Capture.PNG

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

View solution in original post

2 REPLIES 2
Tahreem24
Super User
Super User

@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)

Capture.PNG

 

Final Output:

Capture.PNG

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis
amitchandak
Super User
Super User

@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



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Top Solution Authors