Age grouping in Power BI

[Analitika]

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.

[DOLEARY85]

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 👍