Forum Discussion

Dunner2020's avatar
Dunner2020
Post Prodigy
5 years ago
Solved

Creating date and time table in power query

Hi there,   I want to create a table (in power query)  that has two columns: Date and time:. The date should be starting from 1/4/2020 and ends on 31/3/2025 and time divides into half-hour slot for...
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

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.

Dunner2020's avatar
Dunner2020
Post Prodigy
5 years ago

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? 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    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.