Create Customized Age Bins or Groups in Power BI

Power BI has the built-in feature of creating binning for a numeric field such as age. However, the default binning will create bins of equal size. If you want to create bins of different sizes, then you need to create that as a custom column. Fortunately, Power Query has transformations that can help. In this article, I’ll explain how you create customized age bins in Power BI.
Find the links to study more from my blog article here:

*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

*******************

********
CONNECT with US!
********

********

#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD

[falgufalgu]

Just came back to say a big thank you . I had almost given up after extensive search for a solution for unequal size bin. I’m a total newbie to Power BI

[subhashgauda]

simple and best approach to have something complex you for such a lovely tips and tricks

[mahmoudmohsen]

Liked how you explained the " working concept" of If and Else, Thanks

[alaexanderhawkins]

Excellent. Exactly what I was looking for and so much better than entrusting the binning to the algorithm. Thanks!!

[johnnwakanma]

This is soooo lovely and yet very simple. no helper table needed. Thanks a lot

[akothondiek]

Very helpful video. How come I can't see the newly created age column among the columns from which to create the conditional column? Thanks.

[sidramubashir]

Hii which screen recorder you used in your video? Kindly tell

[akramhemmat]

This is good instead of DAX formula, but some time in age we are receiving errors it should be correct on the address bar because, by this methods we are creating manual formula
.

[juliencauchon]

LEt's just say i can't transform the data, can you point me out to where to do it with a DAX expression.

[praveeng]

Could you pls create a inventory aging Report for given period of time with slots(0-90, 91-120, 121-181...) With inventory and Value of these buckets/slots

[TheKami]

thanks, much appereciated your great work
its solved my problem & helps me alot
Thanks again