Creating New Tables From One Existing Table

[gaurav1991]

Hello Folks,  

Please let me know how to create new table from one Big table. I want to create 3-4 small tables from one big table by applying some filters in it.

In output 1, i need only 3 columns i.e. [ Product | Qty | Size ] with one condition i.e. Size = Large, as shown below

In output 2 need only 2 columns i.e. [ Product | Qty ] with one condition i.e. Sex = Female, as shown below

[v-yulgu-msft · Accepted solution]

Hi @gaurav1991,

OutPut1 =
SELECTCOLUMNS (
    FILTER ( TableName, TableName[Size] = "Large" ),
    "Product", TableName[Product],
    "Qty", TableName[Qty],
    "Size", TableName[Size]
)

OutPut2 =
SELECTCOLUMNS (
    FILTER ( TableName, TableName[Sex] = "Female" ),
    "Product", TableName[Product],
    "Qty", TableName[Qty]
)

Best regards,

Yuliana Gu

[gaurav1991]

@v-yulgu-msft

Thanks, Its Done!