Forum Discussion

DAXRichArd's avatar
DAXRichArd
Resolver I
3 years ago
Solved

Conditional column: grouping data, is there an 'in between' option?

Hello, I work for an airport. I am categorizing commercial aviation aircraft by the FAA's ASPM Weight Class (see https://aspm.faa.gov/aspmhelp/index/Weight_Class.html) My data set is airline self ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi DAXRichArd ,

     

    Please try:

    = Table.AddColumn(
#"Removed Columns", 
"Aircraft Category", 
each if [weight] <= 12500 then "Small" 
else if [weight] > 12500 and [weight] <= 41000 then "Medium" 
else if [weight] > 41000 and [weight] <= 255000 then "Large" 
else if [weight] > 255000 then "Heavy" 
else "NO MATCH"
)

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

css207's avatar
css207
Frequent Visitor
3 years ago

As I know,there is no operator such as between.

  • DAXRichArd's avatar
    DAXRichArd
    Resolver I
    3 years ago

    Hey css207.

    Check out  v-cgao-msft solution using "and".

    Thx for your reply. I appreciate your consideration.

    Have a great day!