Forum Discussion
Solved
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'
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
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