Group ages - then round the number

[lastnn30]

Hi

I managed to create bins to group the age. I do not want group like 19.00 or 30.50.

Instead I want groups without decimals like 19, 30, 42, 53 etc

How can I do that without using DAX. Thank you very much.

 

[V-lianl-msft]

Hi @lastnn30 ,

Maybe you can consider using power query,please refer to:

https://community.powerbi.com/t5/Community-Blog/Group-Bin-in-Power-Query/ba-p/1997205 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[truptis]

@lastnn30 , using DAX you can use TRUNC() 

Eg- TRUNC(19.00) will give you 19

It removes the decimal part.

So try using TRUNC(age)

If this helps then please mark it as a solution & hit the thumbs up. Thanks.

[amitchandak]

@lastnn30 , Please create age as whole number and then create bins

[lastnn30]

Thank you very much for your reply. I made sure the age is "whole number" but still got the same result. I am pasting step by step of what I did, please see below. Thank you once again.