Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Analitika
Post Prodigy
Post Prodigy

Age grouping in Power BI

‎09-21-2023 12:47 AM

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.

Labels:
Message 1 of 2
133 Views
0
1 REPLY 1
DOLEARY85
Super User
Super User

‎09-21-2023 01:16 AM

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 👍

Message 2 of 2
99 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

View All