Reflect same fields twice

Hi AnandAmirtharaj,

In your scenario, if you want to filter all the Manager employees, you have to identify which person is a manager. I don't know how is the source table look like, I suppose the table contains an extra column to mark which one is manager.

Import the same source data twice, then you get two same table, table1 and table2.

In query editor, select table1. Filter data rows. And add an index column.

Select table2, add an index column. Merge these two tables.

In view mode, create a new table using below formula:

Table 2 =
SELECTCOLUMNS (
    'Reflect same fields twice',
    "EmployeeID", 'Reflect same fields twice'[Employee ID],
    "EmployeeName", 'Reflect same fields twice'[Employee Name],
    "ManagerID", 'Reflect same fields twice'[NewColumn.Employee ID],
    "ManagerName", 'Reflect same fields twice'[NewColumn.EmployeeName]
)

If you have any other question, please feel free to ask.

Best regards,
Yuliana Gu