Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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