Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Duplicate the table in Power BI

Hello All,

 

I have a table which have Trend column having values like Daily,Weekly and Monthly.

Now My requirement is I need to duplicate the table and have to take only Monthly data in the new table.

 

Is that possible ?

Could someone please help

 

Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Anonymous 

     

    I briefly simulated some data that I hope fits your situation.

    Table:

    NewTable = SUMMARIZE('Table',[Date],'Table'[Monthly])

    Is this the result you want?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • PC2790's avatar
    PC2790
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Two ways to do it:

    1. Power Query

        In Power Query, you can simply right click on the table you want to duplicate and then from the newly created table delete the unwanted columns

    2. DAX in desktop

       You can write a dax. Go to Table Tools --> New Table and write this:

    NewTable = CALCULATETABLE(SELECTCOLUMNS(<TableName>,"Monthly",[Monthly]))

    I hope any of these solutions solve your purpose

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      H PC2790 ,

       

      I am getting below error for dax function

       

       

       

      • PC2790's avatar
        PC2790
        Icon for Community Champion rankCommunity Champion
        4 years ago

        This has to be your column name from the original table that you want to be included in this new table.

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Anonymous 

     

    I briefly simulated some data that I hope fits your situation.

    Table:

    NewTable = SUMMARIZE('Table',[Date],'Table'[Monthly])

    Is this the result you want?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.