Forum Discussion
Solved
Create a row in a table based on changed date in another table
I want to create a row in a Table2 based on weeks in Table1.
Table1 has a record of numbers in 10 columns each having date
I need to get the average of each column in Table1 for a week and show it in Table2.
A row should be created every week with the averages of Table1 in Table2
In a brief, Table2 should pull the average of Table1 every week new by adding rows
Table1Table2
Does the screenshot show the " error " in the date column? If so the column width needs to be adapted to the size of the data. If you increase the column width the dates are displayed as intended.
Does this return the intended result if the project is included?
You can try Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
The data layout in the screenshot and in the attached file is for illustration. You can place the green result table to the right of the blue table or in another worksheet.It is working well
-I want to change the green table but then the date column is showing an error ####-Can I also separate the weekly averages with 'project' sorting? (In my earlier screenshot)
Does the screenshot show the " error " in the date column? If so the column width needs to be adapted to the size of the data. If you increase the column width the dates are displayed as intended.
Does this return the intended result if the project is included?
