Forum Discussion

gajerose's avatar
gajerose
Regular Visitor
3 years ago
Solved

Using months as headers

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 TypeClubJanFebMarApr
1ARIZ10121521
2PENS17161617
3JACS5101825
Need Help
  • NaveenGandhi's avatar
    NaveenGandhi
    3 years ago

    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.

     

2 Replies

  • NaveenGandhi's avatar
    NaveenGandhi
    Memorable Member
    3 years ago

    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.