Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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))