Forum Discussion
bdehning
Post Prodigy
Post ProdigyConditional 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...
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bdehningPost Prodigy
Post ProdigyI have a Decimal Number Column that provides Years Employed. I use that to create the range of years.