Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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.
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.
It means i need to groupby but also need to create all the measures here aswell
You cannot reach back like this. But you can do the summarization/grouping directly in Power Query.
How to do Summarization in power query