3YR Average by Month

[Melissa]

@jmwdba

Regarding your comment, “Once that’s in place you can include FY columns in your calculations”, does that imply that date hierarchies wouldn’t be needed in the measures, but instead FY columns (i.e. FY Quarter, FY MonthNo, etc.) would replace them?

Precisely, those columns are attributes of a Date and their purpose is to filter, slice and dice your data by. Found an older post that might be of interest to you, just amend it to fit your scenario.

Percentage of Total Sales Average by Fiscal Year

Ok, yes this is a public forum so everyone can see it. I bemused what there is no solution here. It’s really only now that I’ve realised what you need. The total you have is the problem. You wanted to make that total the sum of all the averages. See below for how this is done. This is the pattern anyway. You may have to make some small adjustments Average Sales = VAR AvgSales = AVERAGEX( Sales, Sales[Quantity] * RELATED( 'Product'[Current Price] ) ) RETURN IF( HASONEVALUE( Dates[Month] )…