Dynamic Weighted Average

[asaveliev]

Hi,

A table contains three columns:

• Employee names - multiple rows for each name
• Dates - multiple rows for each name, isn't same periods for each employee
• QTY of hours

Is there a way to calculate average hours worked per employee per week (one number)?

For example , the data is filtered to display 4 weeks period, so the total hours should be dived by emp. qty and week qty, which isn't equal to 4 for all employees.

Thanks,

[v-frfei-msft]

Hi @asaveliev,

Could you please share your sample data and excepted result to me? You can upload your files to onedrive and share the link here.

Regards,

Frank