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 a Date Time Table Script: on the way
Link to a Date Table Script: on the way
Link to a Date Table Script: on the way
Thanks,
Rosh
17 ноя 2023