Forum Discussion
Duplicate Manager Names at Different Levels
- 2 years ago
Anonymous , One of the solutions I can think of is to have the employee name/manager name in a disconnected table. Then you can filter the values selected in one or more column
example countrows(filter(Table, Table[Level1] in values(mgr[empname]) || Table[Level2] in values(mgr[empname]) ))
This is suitable when you have multiple columns, if you have only one column as manager id a duplicate table or inactive join can help
Also check, if needed
- 2 years ago
Step 0: I use a DATA table below.
Step 1: I duplicate 3 column in Power Query Editor.
Before copy
After copy
Step 2: I unpivot these 3 columns.
Step 3: I click 'Close & Apply' and make a matrix and a slicer.
- Matrix -
- Slicer -
- Select 'Bob' -
Step 0: I use a DATA table below.
Step 1: I duplicate 3 column in Power Query Editor.
Before copy
After copy
Step 2: I unpivot these 3 columns.
Step 3: I click 'Close & Apply' and make a matrix and a slicer.
- Matrix -
- Slicer -
- Select 'Bob' -
- Anonymous2 years agoNot applicable
Thank you very much!