Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Create data based on daily time stamps

Hello,

 

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 NameApp CodeDate/Start TimeDate/End TimeDay Of Week
Generic App A111112/4/2022 12:00:00AM12/4/2022 11:59:59PMSunday
Generic App A111112/5/2022 12:00:00AM12/5/2022 11:59:59PMMonday
Generic App A111112/6/2022 12:00:00AM12/6/2022 11:59:59PMTuesday
Generic App A111112/7/2022 12:00:00AM12/7/2022 11:59:59PMWednesday
Generic App A111112/8/2022 12:00:00AM12/8/2022 11:59:59PMThursday
Generic App A111112/9/2022 12:00:00AM12/9/2022 11:59:59PMFriday
Generic App A111112/10/2022 12:00:00AM12/10/2022 11:59:59PMSaturday
Generic App B2222  Sunday
Generic App B222212/5/2022 12:00:00AM12/5/2022 10:00:00PMMonday
Generic App B222212/6/2022 12:00:00AM12/6/2022 10:00:00PMTuesday
Generic App B222212/7/2022 12:00:00AM12/7/2022 10:00:00PMWednesday
Generic App B222212/8/2022 12:00:00AM12/8/2022 10:00:00PMThursday
Generic App B222212/9/2022 12:00:00AM12/9/2022 10:00:00PMFriday
Generic App B2222  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.

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

Your question is not clear.  What are the input columns and what result are you expecting?  What is the use of the End Date column?  Why are there no entries in 2 rows?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

My apologies for the lack of clarity.

 

The two blank rows are meant to represent an application that is offline for that given day. I am hoping to get a table like the input, but with the dates in Date/Start Time and Date/End Time repeating up to a given end date. The Date/Time columns are meant to show the start time and end time of an app's availability in the day shown in the timestamp.

Hi,

Show the expected result very clearly.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.