Forum Discussion
gajerose
3 years agoRegular Visitor
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...
- 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.
NaveenGandhi
3 years agoMemorable Member
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.
- gajerose3 years agoRegular Visitor
Thanks very much!