Forum Discussion
tebtim19
Helper IV
Helper IVFilter 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'
manikumar34
Solution Sage
Solution Sagetebtim19 ,
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
tebtim19Hi, 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
Community Champion
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'