Append tables

[OntheDAXside]

Please I need help!

I need to append or merge these two tables. I grouped Table 1 and it became the same number of rows with Table two and I was able to merge them, I later realized I needed the dates as I want to see the total hrs by person, % of target achieved, and total by person the previous week vs this week. because of the date, I cannot group. I need them on a single table so I can make the above calculations in Dax. I am building a report using SQL server so I can refresh it weekly.  The two tables look like this. Please note I am open to other ways of achieving the same result.

table one		table two
Person	Hours	Date		Person	Planned hours	Plannned days
Aisha John	2	11/12/2021		Aisha John	600	60
Aisha John	1	12/11/2021		Manira Luka	450	45
Aisha John	3	13/11/2021		Philip Man	200	20
Aisha John	4	14/11/2021
Aisha John	2	15/11/2021
Aisha John	4	16/11/2021
Aisha John	6	17/11/2021
Aisha John	4	18/11/2021
Manira Luka	1	13/11/2021
Manira Luka	3	14/11/2021
Manira Luka	4	15/11/2021
Manira Luka	6	16/11/2021
Manira Luka	1	17/11/2021
Manira Luka	1	18/11/2021
Manira Luka	2	19/11/2021
Philip Man	4	14/11/2021
Philip Man	4	15/11/2021
Philip Man	1	16/11/2021
Philip Man	2	17/11/2021

[amitchandak · Accepted solution]

@OntheDAXside , these planned hours are for qtr/year? Based on that we can distribute by having a crossjoin with qtr/year and then using common date and person dimension

PowerBI Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-C...

powerbi Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to...

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

[OntheDAXside]

Thank you @amitchandak