Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm trying to create a table that includes all the dates, hours, minutes and seconds between two set dates. Currently I have this in the DAX :
Solved! Go to Solution.
Hello @whazaaa ,
refer to this article https://kohera.be/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
try this
DateTable =
CROSSJOIN (
SELECTCOLUMNS (
GENERATESERIES ( DATE ( 2022, 9, 1 ), DATE ( 2024, 9, 1 ) ),
"date", [Value]
),
SELECTCOLUMNS (
GENERATESERIES ( TIME ( 0, 0, 0 ), TIME ( 23, 59, 59 ), TIME ( 0, 0, 1 ) ),
"time", [Value]
)
)
You gave a good remark regarding the total rows being 64mil. I've added a different query with only the time and added some time slots (5 sec, 1 min, etc etc)
if I understand you correctly there will be a lot of lines, about 64 million
Hello @whazaaa ,
refer to this article https://kohera.be/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
This didn't actually worked but gave me the idea, I've added a timetable with the help of a youtube vid