This should hopefully be the last topic involving my months long wrangling of app availability data.
I have now hardcoded dates into my data in order to allow for better use of time intelligence functions. Is there a way I can populate data for weeks in the future from these hardcoded dates that would not require me to manually copy and paste the entire data set for a given week?
For an example, let's say I have the following information on two apps below.
|App Name||App Code||Date/Start Time||Date/End Time||Day Of Week|
|Generic App A||1111||12/4/2022 12:00:00AM||12/4/2022 11:59:59PM||Sunday|
|Generic App A||1111||12/5/2022 12:00:00AM||12/5/2022 11:59:59PM||Monday|
|Generic App A||1111||12/6/2022 12:00:00AM||12/6/2022 11:59:59PM||Tuesday|
|Generic App A||1111||12/7/2022 12:00:00AM||12/7/2022 11:59:59PM||Wednesday|
|Generic App A||1111||12/8/2022 12:00:00AM||12/8/2022 11:59:59PM||Thursday|
|Generic App A||1111||12/9/2022 12:00:00AM||12/9/2022 11:59:59PM||Friday|
|Generic App A||1111||12/10/2022 12:00:00AM||12/10/2022 11:59:59PM||Saturday|
|Generic App B||2222|| || ||Sunday|
|Generic App B||2222||12/5/2022 12:00:00AM||12/5/2022 10:00:00PM||Monday|
|Generic App B||2222||12/6/2022 12:00:00AM||12/6/2022 10:00:00PM||Tuesday|
|Generic App B||2222||12/7/2022 12:00:00AM||12/7/2022 10:00:00PM||Wednesday|
|Generic App B||2222||12/8/2022 12:00:00AM||12/8/2022 10:00:00PM||Thursday|
|Generic App B||2222||12/9/2022 12:00:00AM||12/9/2022 10:00:00PM||Friday|
|Generic App B||2222|| || ||Saturday|
What steps would I need to take to get this data to repeat for rest of the month of December, while also keeping the blank spaces for offline apps intact? Thank you in advance.