Forum Discussion
Average Formula
How can I build a DAX formula that will return the average of the highlighted column. I'm trying to do this to get the average by year & quarter:
I do think Unpivot is causing an issue,I am surprised to what average is not calculating row-wise.
IF we fix that everything else will be done
Anonymous Gotcha. I will see if I can recreate everything without unpivoting. Thank you for all your help!