If you click on
Add Column
, then
Conditional Column
Ater the
If
select your reference Column Name,
Operator
'is less than' and
Value
5.
Output
'0-5 Years'
Click on
Add Clause
Select your Reference Column Name,
Operator
'is less than' and
Value
15.
Output
'5-15 Years'
Then in the
Else
section type 'Over 15 Years'
Alternatively use
Add Column
,
Custom Column
and type into the formula box
if [Reference] < 5 then "0-5 Years" else if [Reference] < 15 then "5-15 Years" else "Over 15 Years"
Reference:
M Language Conditionals - PowerQuery M | Microsoft Learn[
^]