Solved: Re: Power query transform combined files

JFGC08 · ‎09-19-2023

Hello,

How can I tranform the left table in to the right table by using power query?

mussaenda · ‎09-20-2023

Hi @JFGC08 ,

View solution in original post

mussaenda · ‎09-20-2023

Hi @JFGC08 ,

JFGC08 · ‎09-20-2023

It worked!! Many thanks.

JFGC08 · ‎09-19-2023

Hi ImKeF,

Many thanks for your feedback. I tested but only worked when aggregate value function is selected different than "Do not aggregate" otherwise it return error.

ImkeF · ‎09-19-2023

Hi @JFGC08 ,
I have described a method for it in this article:
Pivot multiple measures and columns in Power Query (thebiccountant.com)

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Power query transform combined files

Helpful resources

Fabric certifications survey

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024