Forum Discussion

ashaikh's avatar
ashaikh
Helper III
9 years ago
Solved

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

 

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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