Forum Discussion
M Code help
Hii, I am new to Power BI, Zero knowlege about M Code in power query editor, my requirement is I have two tables Table 1 contains two measures (Available Capacity) , (Allocated Capacity) with...
Hi,
you have to group bi your table2 before merging
I hope i understood your need, on the contrary you have to publish sample data and the desired result (in the images of your data there are not any solution)
Hi, thanks for the reply
Table 1
| Year | Month | Customer | Organization | Allocated Capacity | Available Capacity |
| 2022 | 12 | PS-DP | SX/EAB3 | 1 | 1 |
| 2022 | 12 | 2WP-PS-EC | MS/EPE-PJ-PE-2WP | 1 | 1 |
| 2022 | 12 | AS-ER | MS/EVS-SDS-PJ-NXT | 1 | 1 |
| 2022 | 12 | PS-BA | MS/EHB3-PS | 1 | 1 |
| 2022 | 12 | BEG-Non/MCR | MS/EXP4-XC | 1 | 1 |
| 2022 | 12 | PS-Y/NE-SC | MS/ECJ2-PS | 1 | 1 |
| 2022 | 12 | 0A101 | SX/ETL4 | 1 | 1 |
| 2022 | 12 | XC-CT | MS/EXM4-XC | 1 | 1 |
| 2022 | 12 | C | MS/EPE-EV-2WP | 1 | 1 |
| 2022 | 12 | XC-CT | MS/PJ3-ECV-XC | 1 | 1 |
| 2022 | 12 | CC-MB | MS/ESD-FR1-XC | 1 | 1 |
| 2022 | 12 | PS-EC | MS/EDI3-XC | 1 | 1 |
| 2022 | 12 | XC-DX | MS/EEV4-PS | 1 | 1 |
| 2022 | 12 | XC-CT | MS/EDI-XC | 1 | 1 |
| 2022 | 12 | CI | SX/PMO1 | 1 | 1 |
Table 2
| Year | Month | Customer | Organization | PrimSkillSet | BGSW | OSHC |
| 2022 | 12 | XC-CT | MS/EKI1-XC | Program management | 1 | 1 |
| 2022 | 12 | XC-CT | MS/ECS-XC-EP3 | Software Architecture | 1 | 1 |
| 2022 | 12 | XC-CT | MS/ECP1-XC | Project Management | 1 | 1 |
| 2022 | 12 | XC-CT | MS/ECP1-XC | System Test Execution | 1 | 1 |
| 2022 | 12 | XC-CT | MS/ECP4-XC | Product Security | 1 | 1 |
| 2022 | 12 | XC-CT | MS/EDI1-XC | Program management | 1 | 1 |
| 2022 | 12 | XC-CT | MS/EKI2-XC | AUTOSAR Base Software development | 1 | 1 |
| 2022 | 12 | XC-CT | MS/ECT2-XC | Embedded Security development and Integration | 1 | 1 |
| 2022 | 12 | XC-CT | MS/ECO5-XC | Project Management Support | 1 | 1 |
| 2022 | 12 | XC-CT | MS/ESN5-CC | Project Management | 1 | 1 |
| 2022 | 12 | XC-CT | MS/ETW4-2WP | Embedded testing | 1 | 1 |
| 2022 | 12 | XC-CT | MS/ECP6-XC | Management and Support | 1 | 1 |
| 2022 | 12 | XC-CT | MS/ECF2-XC | Embedded Application Software Development | 1 | 1 |
| 2022 | 12 | XC-CT | MS/ECF1-XC | DevOps | 1 | 1 |
So i want to merge tables such that in Table 1 i want BGSW and OSHC coloums to be added
Thanks