Power Query-Pivoting multiple columns to rows

Question

HI 

I need help in power query- pivoting selected columns to rows.  In the file below, if you see the data source, some column fields I need for slicers are coming in a column format where I need it rows so I could do slicers.  Whenever I unpivot the selected columns it impacts other columns and I get this below in the attached image where the values are repeating in row.  Basically, if you see the pivot slicer tabs, that is the grouping I need.  this is just a dummy file as example

Grouping that I want to see in the slicers from power query columns:

Days-d30,d60,d90 columns to rows

Brand: FD,HS,MM,OT columns to rows

Arrang: ARR, SETT, SIN columns to rows

date: is already in the row dont need to do anything

PDT: is already in the row don't need to do anything

File Below:

https://1drv.ms/x/s!AmxTHYioikr1lBhoBQu3vOu1v\_zp?e=URvwz9

Answer 1

Hey Andreas and Ashish,

Can I see the updated file with the ratio calculation for current month rec/previous month mend bal?   So I could follow it in the file?

Ashish-

Can you help me with how you would do it with dax since the above works perfect but if I want to do the image below, if I take pdt column and then take a sub group or attribute..the values come out to be the same...why is that happening?  Since I want to be able to use all the column fields to manipulate the data in different power queries since they have a relationship with the "index column field"

Answer 2

Hi Brandon, 

I wasn't able to get into the link that you provided above.  Can you resend it or another one?  I'm not on tiktok

Answer 3

Please ignore this user, he is obviously here for other reasons, not to help. I deleted all of his posts.

Andreas.

Answer 4

Hi,

You are trying to jump between solutions being provided to you by Andreas and me and therefore i have completely lost interest in this thread.  If you still want me to pitch in, take a small example of 10-20 rows and show me the exact result you want.