Create a relationship between column "Months" and row "months"

[vchauhan011]

Hello,

I have 2 data sets.  One has column called Months with all months listed with their respective hours and another data set has Months as row where each month's hours are listed below in the respective column. I want to create a relationship between the row with all months and columns Months. Would anyone know if it is possible to do in powerBI? if yes, how can I create this relationship? Please see te example below.

January	February
342	557
543	774
634	347

Months	hours
January	342
February	557
January	543
February	774
January	634
February	347

Thank you very much in advance. I really appreciate your help.

[amitchandak · Accepted solution]

@vchauhan011 , Not sure I got it. But you need to use Transform data in Edit Query/Data transformation

Transpose: https://yodalearning.com/tutorials/power-query-helps-transposing-data/

https://radacad.com/pivot-and-unpivot-with-power-bi

[Ashish_Mathur · Accepted solution]

Hi,

In the Query Editor, insert an Index column in the first table.  RIght click on that first column's heading and select "Unpivot other columns".  You should now be able to build a Many to Many relationship between the 2 Tables.

[amitchandak · Accepted solution]

@vchauhan011 , Not sure I got it. But you need to use Transform data in Edit Query/Data transformation

Transpose: https://yodalearning.com/tutorials/power-query-helps-transposing-data/

https://radacad.com/pivot-and-unpivot-with-power-bi

[Greg_Deckler]

I do not know of a way to do that.

Why do you need both tables? I can't fathom a reason.

[vchauhan011]

Thank you Greg_Deckler for looking into this.

I have both tables because my data has two data points, Months and workstreams. The first table is the original data and the second one is the unpivoted table. I want to craete a relationship between these 2 tables so that all graphs are responsive to each other.