Forum Discussion
Filter Added new Column
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.
- 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'
5 Replies
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
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
- 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'
- 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 tebtim19 , what is logic needed ?
if(isblank([manager]), blank(), 1)
