Forum Discussion

bdehning's avatar
bdehning
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

Conditional Column Question

Let me try this question another way.    I have the following Conditional Column that works for Numerical sorting. How can I add an Else if to continue from 5-50 without having to create 46 more Else...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi bdehning ,

    According to your description, here's my solution.

    Add a custom column in Power Query.

    if [LOE By Year]=null then "No Data" else if[LOE By Year]<1 then "< 1 yr"else if [LOE By Year]<2 then "1 yr" else Text.Combine({Number.ToText(Number.RoundDown([LOE By Year]))," yrs"})

    Result:

    Then in Desktop, select the LOE Range column, click Column tools>Sort by column>LOE By Year.

    Get the expected result:

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi bdehning ,

According to your description, here's my solution.

Add a custom column in Power Query.

if [LOE By Year]=null then "No Data" else if[LOE By Year]<1 then "< 1 yr"else if [LOE By Year]<2 then "1 yr" else Text.Combine({Number.ToText(Number.RoundDown([LOE By Year]))," yrs"})

Result:

Then in Desktop, select the LOE Range column, click Column tools>Sort by column>LOE By Year.

Get the expected result:

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.