possible to compare current month avg to entire last year avg and show it a bar chart with dimension being Month Year?
Also, put a condition to check if the there was a Sale for the same product in both only then use it average or exclude from calculation.
I am currently using below- calculation as a measure but only get value for Dec which doesn't seem correct
(Sum(aggr(avg(REVENUE),CUSTOMER_TYPE,[Product Family]))
-Sum(aggr(avg({$<Year={"2019"}>}REVENUE),CUSTOMER_TYPE,[Product Family]))
)
/
Sum(aggr(avg({$<Year={"2019"}>}REVENUE),CUSTOMER_TYPE,[Product Family]))
Sorry for direct tag but i am in no luck with finding similar topics here
@sunny_talwar