AVERAGEX function calculates a value for each row in a table, and then finds the average of the calculated values.
You can use the
AVERAGEX function in a pivot table to find the average age of beneficiaries. For example, if you had a quantity field in your form with
AGE of the beneficiary, then you could write:
The second argument can be expression in a row context, for example if we wanted to find the average of our beneficiaries at particular moment in time, we could write:
AVERAGEX([Beneficiaries], YEARFRAC([Date of Birth], DATE(2023,1,1)))
This finds the average beneficiary age on January 1st, 2023.