Forum Discussion
Advocate IIHow to group data from one column?
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
Helper I
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
Advocate IIHoly, 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 ^^
- haymanezzeldin
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
- 0xygen27
Thank you for helping me out!