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

[Sohaib]

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?

[lbendlin · Accepted solution]

[v-xinruzhu-msft · Accepted solution]

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.

[Sohaib]

It means i need to groupby but also need to create all the measures here aswell

[lbendlin]

You cannot reach back like this. But you can do the summarization/grouping directly in Power Query.

[Sohaib]

How to do Summarization in power query

[lbendlin · Accepted solution]