cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ashaikh Member
Member

Sort week duration

I have a calculated column in Power BI which is week duration from Sunday to Saturday. 

 

Example

1/3/2017 - 1/9/2017

1/17/2017 - 1/26/2017

1/10/2017 - 1/16/2017

 

I want to sort this column in ascending order. How can I do that.

 

Thanks in Advance

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Sort week duration

Hi @ashaikh,


If you want to sort these records by week duration, why don't you direct  add the week number and sort by week number?

 

For example:

Add a column to analysis above text to week number, sort by the week number column.

 

Sample formula:

WeekNumer = WEEKNUM(DATEVALUE(LEFT([Date Range],SEARCH("-",[Date Range])-1)),1)

 

Capture.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
1 REPLY 1
Community Support Team
Community Support Team

Re: Sort week duration

Hi @ashaikh,


If you want to sort these records by week duration, why don't you direct  add the week number and sort by week number?

 

For example:

Add a column to analysis above text to week number, sort by the week number column.

 

Sample formula:

WeekNumer = WEEKNUM(DATEVALUE(LEFT([Date Range],SEARCH("-",[Date Range])-1)),1)

 

Capture.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |