Forum Discussion
Create new table from another and condition
Hi all,
I'm looking to achieve the following:
Table1
| id | Name | status | Role |
| 1 | Alpha | Active | Supplier |
| 2 | Beta | Non-active | customer |
| 3 | Zoulou | Active | Supplier |
New Table ( id, name where status = Active and Role Supplier)
| id | Name |
| 1 | Alpha |
| 3 | Zoulou |
Thx in advance for your help.
Guy
Perhaps:
New Table = SELECTCOLUMNS( FILTER( 'Table1', 'Table1'[status] = "Active" && 'Table1'[Role] = "Supplier" ), "id",[id], "Name",[Name] )
3 Replies
Perhaps:
New Table = SELECTCOLUMNS( FILTER( 'Table1', 'Table1'[status] = "Active" && 'Table1'[Role] = "Supplier" ), "id",[id], "Name",[Name] )You are welcome Anonymous !!