Automate the condition and fill the table

Copper Contributor



I need to update a weekly and daily report based on given data. Can you kindly support?

Condition is, when the percentage first reach greater than 70% I need to put the Item code in my weekly table based on the date. How can I do this automatically instead of entering manually.



I have attached my file for your kind reference.




3 Replies

Hi @Chris525 


With Power Query:


  • Formatted your data as Table (you can hide row #4)
  • Dates (Tuesdays) in WeeklyTuesday table (output of the query) are dynamically generated according to dates found in Table1

To update: Right-click somewhere in WeeklyTuesday > Refresh

@L z. Thank you so much!



You're welcome @Chris525 

Feel free to click Mark as answer link (at the bottom of the post) to help people who Search :) - Thanks