Hi, I’m trying to work out a scenario (which I have looked for in the forum but haven’t found).
Data is composed of three years (2018, 2019 and 2020) - Jan and Feb contains Sales 2019 and 2020
I want to showcase current year Sales by MonthNameShort as columns, and then add a line for the Average Sales 2 Yrs Prior curve by MonthNameShort.
Sales = DIVIDE( [Revenue 000’s], 1000)
Avg Sales = AVERAGEX (ALL(‘Calendar’[MonthNameShort] ), [Sales] )
Avg Sales 2 Yrs Prior = AVERAGEX ( FILTER(‘Calendar’, ‘Calendar’[Year] = “2019” || “2018” ), [Sales])
The latter isn’t working - see below error message - don’t understand since Year filed in Calendar isn’t text:
So, Jan should show total Act Sales as column and Avg 2 Yrs Prior as line.
Once accomplished this, I would like to show the variance in $ and % for Act vs Avg 2 Yrs Prior curve in the same visual.
Last, add countries to be able to drill down.