Forum Discussion
Merge Tables with Duplicate Column Names and Add Values
Hi Grant82 ,
You can create a new blank query and paste the above code into the advanced editor to reference the steps.
You can also watch ImkeF's video to learn how to integrate M-code into your existing solution.
Power BI Forum Help: How to integrate M-code into ... - Microsoft Fabric Community
Hope these help.
Best Regards,
Gao
Community Support Team
Thank you I've watched the video and tried my best, but still need some help I'm sorry to say. I have transposed and then used the advanced editor to add the grouping step with the code you've supplied. It has not produced the desired effect unfortunately. The final grouping table seems to show just one month's data now, but it has added a row at the bottom called AA which has 2 in it - I'm not too sure what that number is either.
With these screenshots:
1. both dates are in the same row of data
2. those values look like the values from the first month only
3. aa row
But I'm using this data to track these values over time so I need a row for each month. Also, with this data I had the first CSV having only one of each variable name. Then in the second month it created 3 idential "Job Tech" variables with values in each - I thought this may sum the values of them for that month (I'm just confirming we're on the same page).
Have I incorrectly implemented your solution or was it not designed to work how I expected it? Sorry if I explained poorly what I'm looking for!
I do very much appreciate your help.