Forum Discussion
matratus28
Resolver I
Resolver ISingle Average Value in Power Pivot / DAX
Hi, I've got a data set of product sales and volumes. The data is at week, product and customer level. The 1st 13 weeks are my BASE VOLUMES and I want to calculate the average volumes for the comb...
I found a solution that looks for all the volumes if in the week is before 202514 and divides by 13
That then overrides the week in the pivot table and gives just the average for the entire 13 weeksBaseAverageEACHES:=CALCULATE(
SUM(t_volumes[EACHES]),
t_volumes[Timeframe] = "Baseline",
t_volumes[Week] <=202513
) /13
matratus28Resolver I
Resolver II found a solution that looks for all the volumes if in the week is before 202514 and divides by 13
That then overrides the week in the pivot table and gives just the average for the entire 13 weeks
BaseAverageEACHES:=CALCULATE(
SUM(t_volumes[EACHES]),
t_volumes[Timeframe] = "Baseline",
t_volumes[Week] <=202513
) /13