Forum Discussion
Append tables
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 |
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-Convert-to/ba-p/1476400
powerbi Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to-Daily/ba-p/1463290
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-solution-8e3eccb41bda
2 Replies
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-Convert-to/ba-p/1476400
powerbi Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to-Daily/ba-p/1463290
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-solution-8e3eccb41bdaThank you amitchandak
