Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm having trouble figuring out how to create a custom column to categorize Age.
In the picture below I have employees and their age, I would like the custom column to categorize into:
<25
25 - 30
31 - 35
36 - 40
41 - 45
46 - 50
51 - 55
55 - 60
61 - 65
66+
Is this possible in Query Editor? I tried a conditional column but couldnt get it to work out so my next try would be Custom Column, but I'm not even sure if that would work. Hoping for someone to help here 😃
Thank you
Solved! Go to Solution.
Hi,
You can do it in query editor using conditinal columns.
Here's the M-code that got generated for a sample dataset.
You can change it to suit your age group requirements.
= Table.AddColumn(#"Changed Type", "Age Group", each if [Age] <= 10 then "1 - 10" else if [Age] <= 20 then "11 - 20" else if [Age] <= 30 then "21 - 30" else "Other" )
Please accept this as a solution if it satisfies the requirement. Appreciate your Kudos. 🙂
Thanks.
Hi,
You can do it in query editor using conditinal columns.
Here's the M-code that got generated for a sample dataset.
You can change it to suit your age group requirements.
= Table.AddColumn(#"Changed Type", "Age Group", each if [Age] <= 10 then "1 - 10" else if [Age] <= 20 then "11 - 20" else if [Age] <= 30 then "21 - 30" else "Other" )
Please accept this as a solution if it satisfies the requirement. Appreciate your Kudos. 🙂
Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |