Create new table from another and condition

[Anonymous]

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 

[Greg_Deckler · Accepted solution]

Perhaps:

New Table =
  SELECTCOLUMNS(
    FILTER(
      'Table1',
      'Table1'[status] = "Active" &&
        'Table1'[Role] = "Supplier"
    ),
    "id",[id],
    "Name",[Name]
  )

[Anonymous]

Many thanks Greg!

[Greg_Deckler]

You are welcome @Anonymous !!