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.
Hi,
I have a column called TYPE that holds various employement types (perm, freelance, FTC, intern) and I would likle to create a new column that merges some of these types into one.
For example I would like to create a new column that holds all employement types other than perm.
Can someone advice on a calc i can use to do this?
Many thanks,
Solved! Go to Solution.
Hi @Anonymous,
try this for your calculated column:
NewColum = IF(Table1[Type] = "perm", "perm", "not perm")
@Anonymous - There are several ways to create a new column to group values. However, you would not be excluding Perm - instead you would put it in it's own group. You could use a Custom column in Power Query, a Calculated Column with DAX, or use New Group. In any of the methods, you need to set the new column's value based on the value in the original column.
Here's the New Group option:
Cheers!
Nathan
Hi @Anonymous,
try this for your calculated column:
NewColum = IF(Table1[Type] = "perm", "perm", "not perm")
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |