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, Me...
  • NaveenGandhi's avatar
    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.