Forum Discussion

Sohaib's avatar
Sohaib
Helper II
2 years ago
Solved

How to append two Customize table which are created using summarize function in Power BI

Hi,     I need to append two tables which actually created in power BI from summaization fucntion from the "main or fact table". How we can add this is in blank query to append these two table or ca...
  • lbendlin's avatar
    lbendlin
    2 years ago

     

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Sohaib 

    Thanks for the solution lbendlin  provided, and as lbendlin  said, you can use group by to summerize, and if you need to create them as new tables, you can refer to the following solution.

    You can duplicate the table first, then in the dupliccated tables, you can use the group by to summerize.

    Then rename the tables to 'Daily Table' and  'Hourly Table'.

     

    Best Regards!

    Yolo Zhu

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