Average if - expression help please

I have a table and I need to build a Virtual column with averages.  I need an average of column [DSO] based on two things:

Date [year] = "Current year" ( I already have a virtual column "year")

Branch [branch] (I have 7 different branches PLUS my "Total" = so It will calculate 8 Averaged DSO)

TABLE:

[Key]    [Date]   [Branch]    [DSO]

 

SNIPPET OF DATA/TABLE:

 

Tiger1_1-1730474557119.png

 

Solved Solved
0 6 170
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5
6 REPLIES 6
Top Labels in this Space