Forum Discussion
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 can we append these two tables in table view section. Please help
The below image you can see 3 tables "Daily", "Hourly" and "data". The 2 tables "Daily and Hourly" is actually drives from "data" table using summaization function.
How we use these 2 tables as source for blank query?
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.
5 Replies
You cannot reach back like this. But you can do the summarization/grouping directly in Power Query.
It means i need to groupby but also need to create all the measures here aswell
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.
