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 c...
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

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