Sort week duration

[ashaikh]

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

[Anonymous · Accepted solution]

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)

Regards,

Xiaoxin Sheng