Automate the condition and fill the table

Copper Contributor

Hi,

 

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.

 

Chris525_0-1717400561975.png

I have attached my file for your kind reference.

https://www.dropbox.com/scl/fi/yncvyaw6rghsn7s1w4pgm/Automate-the-fomulas.xlsx?rlkey=txk09lv041bgtdk...

 

Thanks

 

3 Replies

Hi @Chris525 

 

With Power Query:

Sample.png

  • 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