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 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
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)
10 Replies
- serpiva64Solution Sage
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).
- AnonymousNot applicable
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
- AnonymousNot applicable
Thanks for the reply im new here how can i post sample data ?
- serpiva64Solution Sage
copy and paste
- AnonymousNot applicable
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