How to Create a Date Table, Date Time Table and Time Table in Power BI
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- How to Create a Date Table in Power? or How would you create a Date Time Table in Power BI? or even creating a Time Table in Power BI.
In this video, I am going to show you guys how we can create a date time table, date table and time table in Power BI.
Creating a date table is very popular practice in Power BI but, you use date table for a daily reporting right? But what if you want to create shift
reports?
In order to create shift report, say you have 12 hours shifts in a day so, two shifts in a day, you will need to create a date time table. But, even more interesting is how you are going to create a time table where, you can report on a dataset based of hour or minutes.
Let's find out how we create a calendar date table, date time table and time table in Power BI.
And as promised, codes for the tables are shared below.
Just Copy and paste is in your advanced editor.
Link to Scripts: drive.google.c...
Thanks,
Rosh
Access scripts here: drive.google.com/drive/folders/1wRaGsy_Cx410y0Dw3n3sJdMfjv-LVxzl?usp=drive_link
This is really amazing Rosh.
Is it possible to make a tutorial on only Date Time Table?
I need help in creating a date time table for our shift report.
Struggling to create a table for our shift starting at 7:45 AM and 7:45 PM. Could you please help me with this? 🙏🙏🙏
Sure. I will do upload one for date time table. Thanks for your support
Thanks for this great video.
Glad you liked it!
Hello thanks for the video, but I do not see the scripts in the description as it says in the video. Any help?
Hey Daniel,
Find the scripts here drive.google.com/drive/folders/1wRaGsy_Cx410y0Dw3n3sJdMfjv-LVxzl?usp=drive_link
Instructions in the description of this video.
Hi, can you please share the code. The links just say "On the way". Also wondering how you would relate these if using in a report
Excellent video!
Glad you liked it! Thanks
👏
How to Set Up the Relations in the datamodell?
Link your date, DateTime or time column of your fact table to the date, DateTime or time table
Ensure you create one to many relationship.
Hope this helps.
@@powerbitutorialforbeginners
I have 4 fact tables 2 with Date and 2 withdatetime. Also 1 Date and 1 datetime tables conected to each other. The 2 fact table with datetime are connected to the datetime table and the 2 facttables with Date are connected to the Date table. Can the datamodell exist Like this?
Can you make a tutorial on Date Time Table please? I need a date time table for every hour of the day. Can you help?
Sure. I will create a short one for the date time table
Data set link