Forum Discussion
Creating date and time table in power query
Hi, Dunner2020
Please correct me if I wrongly understood your question.
In my case, I generally create two separately.
Dim-Date-Table
Dim-Time-Table
And, in the fact table, I duplicate the date-time column, then I make one for Date only and another for Time only.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Jihwan_Kim , it sounds right. But I did not get it. Could you please explain it with some example?
Hi, Dunner2020
Thank you for your feedback.
Please correct me if I misunderstood your question.
For instance,
if you have a fact table like below, ( inside one column, there are date and time)
You can duplicate like below, and make one column => only date, and another column => only time
Then, you can connect Date-Only-Column to dim-date-table,
and Time-Only-Column to dim-time-table.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Jihwan_Kim , But I need a half-hourly time slot. In your example, you have an hourly time slot. Can we change it to a half-hourly slot?
Hi,
Sorry to make confuse.
I just made up the above sample.
You can create even a minute-time slot.
The key is to use a separate dim-time-table.