Forum Discussion

gaurav1991's avatar
gaurav1991
Regular Visitor
8 years ago
Solved

Creating New Tables From One Existing Table

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

 

 

 

 

Need Help
Show and Tell
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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