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.

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.