Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Community,
I am wondering about a formula I want to use. I got a database with a column for
-Date
-Department
-Employees
I am wondering if i can use a formula to group some departments in a group in a different table. For example group Sales department and marketing department.
All the departments are now only in one column.
Greetings, 0xygen27.
Solved! Go to Solution.
In such situation you can use multiple filter using the "or" sign ||, as follows:
Table = Filter(Sheet1, Sheet1[Department]="Sales"||Sheet1[Department]="Purchase")
Regards,
Hayman
I don't think there is a criteria that combines the departements with each other. I am looking for 3 groups in which I can place these departments (For example :primary process,Secondary and administrative process)
Is there a formula where I can make a Table and filter particulair departements into that table?
So the columns are like this
Column
Date Column Department Column Employees Column Phones active at department
11-02-16 Sales 110 60
11-02-16 Purchase 60 40
11-02-16 Bosses 4 4
18-02-17 Sales 110 60
18-02-17 Purchase 60 40
18-02-17 Bosses 4 4
28-03-17 Sales 110 60
28-03-17 Purchase 60 40
27-03-17 Bosses 4 4
I want to place Sales and Purchase in a Table together and name it Primary process, So i can show how many % of the Primary process uses a phone and filter on it.
I want to make a chart which shows me the information of my whole company and in which I can zoom in on the 3 groups and then zoom in on the departments.
You can use Calculated Tables to create a copy of the existing one, and just use DAX filter to eleminate the Bosses records:
Table = Filter(Sheet1, Sheet1[Department]<>"Bosses")
Regards,
Hayman
Holy, thank you. It is working. Is there also another function which I can use the opposite way? So that I only have to type the things I want in it? I got a lot of departments to work with ^^
In such situation you can use multiple filter using the "or" sign ||, as follows:
Table = Filter(Sheet1, Sheet1[Department]="Sales"||Sheet1[Department]="Purchase")
Regards,
Hayman
Thank you for helping me out!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |