cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bloffet
Frequent Visitor

Create table based on conditions in the current table

Hi all,

 

I've an "Employee" table which contains all the employees from a company. In this table, in addition to the name, function, etc. there is one column with the employeeID, and another one with the ManagerID (each manager is also a row in the Employee table, and thus has an employeeID too).

 

I'd like to create a separate table to store only Managers.

 

Could help me on the filter to use to build this ?

 

Manager = CALCULATETABLE('Employees; 'Employees'[MANAGERID] in (...))

 

I know how I would do it in SQL, but not really in Power BI with DAX formulaes.

 

Thanks for your help

Benoît

1 REPLY 1
Mahesh0016
Solution Sage
Solution Sage

@bloffet 
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors