Average if - expression help please

[Tiger1]

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:

[Steve · Accepted solution]

Same idea: How do I do COUNTIF() or COUNTIFS()? 

[Tiger1]

Thanks Steve, 

I am still not getting this (see below):

[Steve]

This happens to me when I'm using a slice that doesn't include the column. Make sure that Historical DSO Download Table includes the Branch column.

[Tiger1]

It does, but it is a Ref.  Is that the problem?

[Steve]

What about the table that includes the Baytown column?

[Tiger1]

Got it working.  Thanks AGAIN Steve!