M Code help

[RamaKrishna_B6]

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 dimmensions year,month, Customer,Organization

Table 2 Contains two measures (BGSW),(OSHC) with Dimensions year, month, Customer , Organization , Prim Skillset ( Extra Dimension in Table 2

Requirement is i want two measure coloums BGSW and OSHC from Table 2 in to Table 1 . please help me in M code

(i.e) I can do this in DAX but i have to do in power Query editor beacuse after getting coloums in to table 1 i need to transpose the table

Please help me in M code or suggest me any M code learing article so i can solve this problem

[RamaKrishna_B6]

Thanks for the reply im new here how can i post sample data ?

[serpiva64]

copy and paste

[RamaKrishna_B6]

Hii i dont know i posted data 5 times after refreshing the page the post getting deleted

See this is how i posted more than 5 times

[serpiva64]

Sorry i misunderstood your problem

you have to try to merge tables

(You have to select the column in the same order)

then expand the columns you want.

Pay attention if the combination of the column you select creates an unique combination (the number of rows in table 1 should be the same after merging)

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!

[RamaKrishna_B6]

Hey thanks for the reply and I am sorry i couldnt explain you clearly

thanks for your efforts for creating PBIX file and explaining me

see if you look in PBIX file you have shared Table 1 and Table 2 has same rows i mean one to one relation

** But my requirement is For Example in Table 1 Customer has a row  as  A item ok adjacent to A there are Available Capacity and Allocated Capacity right

In Table 2 same Customer A item has two or three BGSW and OSHC because it has has primskillset Coloum 

so i want to get BGSW and OSHC coloums in Table 1 with out consideration of primskillset

Hope i am clear now 

[serpiva64 · Accepted solution]

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)

[RamaKrishna_B6]

Hii,

I got it, my requirement got fulfilled thank you so much for your patience even i couldn't explain my requirement clearly..

[RamaKrishna_B6]

[RamaKrishna_B6]

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 

[serpiva64]

Hi,

i think that what you are trying to do is not possible.

You have first in power query to create your measures adding columns to your queries then you can try to merge the queries.

Please post some sample data (not images).