The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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):
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
Solved! Go to Solution.
is this what are you looking for?
List.DateTimes(#datetime(2022,1,1,0,0,0),3*24*365,#duration(0,0,20,0))
is this what are you looking for?
List.DateTimes(#datetime(2022,1,1,0,0,0),3*24*365,#duration(0,0,20,0))