Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sorting Column based on the another column

Hi All, We have data like below image :-   Based on the sort range column I want to create one another column where sort range contains “>-“ it will be 1 and if sort range contains “>” i...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Please check the formula.

    Column =
IF (
    CONTAINSSTRING ( 'Table'[range], ">-" ),
    "1",
    IF (
        CONTAINSSTRING ( 'Table'[range], ">" ),
        SUBSTITUTE ( 'Table'[range], ">", "" ),
        'Table'[short range]
    )
)

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Please check the formula.

Column =
IF (
    CONTAINSSTRING ( 'Table'[range], ">-" ),
    "1",
    IF (
        CONTAINSSTRING ( 'Table'[range], ">" ),
        SUBSTITUTE ( 'Table'[range], ">", "" ),
        'Table'[short range]
    )
)

 

Best Regards,

Jay