Forum Discussion

OntheDAXside's avatar
OntheDAXside
Frequent Visitor
3 years ago
Solved

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 dat...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

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