So I'm new to calculate columns and DAX with PowerPivot. I think I have a fairly simple problem that needs to be solved in powerpivot. I have 3 columns in PowerPivot - "Financial Version", "Fiscal Year", and "Amount."

What I want to do in Excel terms is AVERAGEIFS. So =AVERAGEIFS([Amount],[Financial Version] = "Actuals", [Fiscal Year] <> 2017)

I explain it in an excel formula because that is what I understand. Is this possible to do using powerpivot? Or is there another way I should be thinking about getting this result?

Thanks.