Using months as headers

[gajerose]

I have an excel table with 5 columns of data. The month columns represent the Base Size of the Membership Types over time. How can I use this in Power Bi to use Base Size as a measure. In essence, Membership Type, Club and Base Size would be the 3 measures, and I would be able to define the growth using Date.

Membership Type	Club	Jan	Feb	Mar	Apr
1	ARIZ	10	12	15	21
2	PENS	17	16	16	17
3	JACS	5	10	18	25

[NaveenGandhi · Accepted solution]

Hello @gajerose 

You can transform the table structure as below by using unpivot columns, This would make it easier for you to do calculation further.

Let me know if this helps or if you are looking for another type of solution.

Regards

Naveen

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

[gajerose]

Thanks very much!