Filter Added new Column

[tebtim19]

I have a table with status

Contractor, Staff, Vendor, Manager

I need to create new column

That it will show the name of the person who have manager status.

[amitchandak]

@tebtim19 , what is logic needed ?

if(isblank([manager]), blank(), 1)

[AllisonKennedy]

Are you wanting to do this in Power Query? Is the name of the person in the same table or a different table? If the same table, you can click Transform Data in the Home tab, then select Add Column > Conditional Column and add the column using the dialog box help.

If the Name of the person is in a different table, we need more information about both tables - what is the identifying key columns that connect them both?
https://excelwithallison.blogspot.com/2020/08/its-complicated-relationships-in-power_11.html

[manikumar34]

@tebtim19 , 

Not Clear, 

If you are looking to match the status with another table use Merge in Power Query or create a relationship on Status. 

If you want to answer your question quickly, please pose question with proper deatils and if possible share sample data. 

Regards, 

Manikumar

[tebtim19]

Hi, okay this are the sample tables

Name	Status	Location	Gender
Ana	Vendor	UK	Female
Ben	Manager	UK	Male
Jon	Staff	PHP	Male
Kyra	Manager	UK	Female
Linda	Staff	PHP	Female
Gina	Manager	UAE	Female
Porchia	Manager	PHP	Female

Now I want to make another column which will give me the name of the status Manager which are

Ben

Kyra

Gina

Prochia

I need this column so I can eaily use this to create a slicer of option of managers

[AllisonKennedy · Accepted solution]

You have only provided one sample table? Are there multiple tables or are all columns in one table? If all in the same table, you can just add [Name] to a slicer. Then you have the ability to add [Status] to the 'Filters on this Visual' without needing to put [Status] actually in the visual. Set that filter to basic and select 'Manager'