Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Analitika
Post Prodigy
Post Prodigy

Age grouping in Power BI

Hello,

 

I would like to ask how to make age grouping in power bi. I have column age. I need make like 0-10, 11-20 etc.

1 REPLY 1
DOLEARY85
Super User
Super User

Hi,

 

you could create a custom column in power query with a formula such as:

 

if [Age] >=0 and [Age]<= 10 then "1-10"
else if [Age] >=11 and [Age]<= 20 then "11-20"
else "21+"

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.