Forum Discussion
Solved
Please help
Hello - I have a column with the age of the company , ranging from age 1 to 100 , I'm trying to create a new custom column (Company Age Range) in power query that will give the value something like b...
The easiest way is to use a custom column. The Conditional Column feature won't work as it will try to interpret 6-10 as a date.
The formula would look like this:
if [Age] <= 2 then "0-2" else if [Age] <= 5 then "3-5" else if [Age] <= 10 then "6-10" else nullJust continue adding more 'else if' clauses until you have it like you want. You must include the final "else" statement, so it could be else null, or your final result, else "N/A"
The easiest way is to use a custom column. The Conditional Column feature won't work as it will try to interpret 6-10 as a date.
The formula would look like this:
if [Age] <= 2 then "0-2"
else if [Age] <= 5 then "3-5"
else if [Age] <= 10 then "6-10"
else null
Just continue adding more 'else if' clauses until you have it like you want. You must include the final "else" statement, so it could be else null, or your final result, else "N/A"
