filtering on a new column

[Anonymous]

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,

[Anonymous]

@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

[AlB · Accepted solution]

Hi @Anonymous,

try this for your calculated column:

NewColum =
IF(Table1[Type] = "perm", "perm", "not perm")