Hi, I have a table called Users with columns Type & Name. I need a new column called Male which will take all names in Name only iftheir corresponding value in Type is Male. Should look something like this

Well, the equivalent third column would be Female = IF(Table[Type] = "Female", Table[Name], BLANK()) As with the Male category it would just be blank on male rows. You couldn't accomplish this - where "this" means that example thing you made in Excel - with filters. But presumably you want to use this column for something. Whatever that something is you could probably do it with filters. How to accomplish that something depends entirely on what that something is.* As a trivial example: if you wanted a list of male names, you could just add a table or matrix visual with Name in the rows slot, then add Type to the Visual Level Filters box and check "Male" in that filter. *Good Lord that sentence probably killed 10 non-English speakers trying to decipher this thread. And probably 5 English speakers.

New Column based on values in 2 other columns

Forum Discussion

Related content

Matching Column Values

Splitting Column values

Check column for similar values

New Column

Grouping rows by Column and then updating Column