Forum Discussion

ThomasDay's avatar
ThomasDay
Icon for Impactful Individual rankImpactful Individual
10 years ago
Solved

Create table of merged columns

Hello all, I'm looking to accomplish the below picture using a Query.  If it's possible to do, I would very much appreciate a "pattern" that can get me started.  I've tried to do this unsuccessfully...
  • Sean's avatar
    Sean
    10 years ago

    Should be able to... Eventually you will have to load something... (that post I think was about someone loading 3 tables that were supposed to be appended - then appending and not wanting the original 3 in the data model just the appended) 

     

    Seems to work for me when I add new data to the source

     

    Did you get it to work in your case?

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

ThomasDay Isn't this nice? No line of M? I just hope ImkeF approves of the solution? 

 

Also let's hope they add intellisense to the Query Editor - will help us to learn M much faster.

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
10 years ago

Hey guys,

all thumbs up of course :-)

Pivot is really one of the coolest features - but it really shines in the "unpivot and pivot-back"-combination (you see: I also can no code :-) )