I've like t write a measure to calculate the average sales for each year;
I've tried a couple of methods, one ;
![]()
Please Login or Register to view this content.
Which give the correct answer providing all dates / months have values in them
I have also used AVERAGEX with crossjoin,
This works but can I just use average and wrap in calculate to remove or keep filter context as required, as for the denominator in a percentage?![]()
Please Login or Register to view this content.
Workbook attached.
Richard.
Bookmarks