Forum Discussion
Helper ICalculate a weekly average from measures based on multiple columns
Helper IHi Matt,
Thank you for the feedback. I'm actually looking to calculate the average interactions per week. I think I've found a solution (described above) but would be interested in your thoughts on any improvements/better approaches. Also Could you tell me how to unpivot the data - I've struggled with getting people I work with to provide data unpivoted as it's more user-friendly for them to produce it in pivot format. However I find it much easier to work with unpivoted so am very keen to understand how to do that.
Solution SageHi SimonJacobs
See this article about Pivot & Unpivot: http://radacad.com/pivot-and-unpivot-with-power-bi
It is basically a native functionality of the Power Query user interface.
I always try to get my data unpivoted - it makes data analysis MUCH easier.