Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 reported data for landings.
I want to group aircraft into 4 categories based on ranges of weight in pounds.
I've solved it for now creating a conditional column and using the order of execution going from small to large.
There are greater than equal to operator >=, less than <, .....
Question: is there a way to create an "inbetween" operator?
>< not equal to.
<> between?
Here is the query code from the conditional formating feature.
The targt column for the grouping is the [weight] column.
Thx in advance for all your help.
= Table.AddColumn(
#"Removed Columns",
"Aircraft Category",
each
if [weight] <= 12500 then
"Small"
else if [weight] <= 41000 then
"Medium"
else if [weight] <= 255000 then
"Large"
else if [weight] > 255001 then
"Heavy"
else
"NO MATCH"
)
Solved! Go to Solution.
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
As I know,there is no operator such as between.
Hey css207.
Check out v-cgao-msft solution using "and".
Thx for your reply. I appreciate your consideration.
Have a great day!
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
Hi v-cgao-msft,
IT WORKED!
Big thx for all the help.
I'm a novice at MQuery, however I can find solutions just hacking away. Hope to be a Master at it like you one day.
Merry Christmas and have a wonderful New Year.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
11 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
7 | |
6 |