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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
frittle
Helper II
Helper II

Create a list in Power Query that contains 20 minute timestamps for every day in 2022

Hello Power Bi Community,

I am rather new to Power BI and especially power query. I have a list that contains all 20 minute timestamps for 24 hours as you can see below (72 Rows):

 

frittle_1-1650742349344.png

 

 

Could someone please show me how I can add the date to every column to create a timestamp list for every day in 2022 with 20 minute intervals? (yes, this would be a very long list). Date span should be between 01.01.2022 - 31.12.2022 (european date) (dd.mm.yyyy)

Any help is highly appreciated!


Best Regards
Leo

1 ACCEPTED SOLUTION
Anonymous
Not applicable

is this what are you looking for?

List.DateTimes(#datetime(2022,1,1,0,0,0),3*24*365,#duration(0,0,20,0))

View solution in original post

1 REPLY 1
Anonymous
Not applicable

is this what are you looking for?

List.DateTimes(#datetime(2022,1,1,0,0,0),3*24*365,#duration(0,0,20,0))

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors