hi any help how to create time dimension in power bi

[Aruna_ln]

i now how create dynamic calender date dimnsion like below link.

https://www.mssqltips.com/sqlservertip/4857/creating-a-date-dimension-table-in-power-bi/

but i need Hour and Second  also

plase any body help this

thanks

aruna

[adeeln]

Follow below simple ways

• https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
• https://radacad.com/how-to-use-time-and-date-dimensions-in-a-power-bi-model
• https://www.fourmoo.com/2019/08/28/creating-a-time-dimension-using-the-power-query-editor-in-power-b...

[Mi2n]

hour = Hour([Date])

second = Second([Date])

These should help!

[Aruna_ln]

Hi rhanks replay,

But i didn't have date measure.
I need create date and hour and seconds
Between 1 jan 2016 to 1 jan 2019

[v-sihou-msft]

@Aruna_ln

I highly recommend you separate Date and Time table to avoid too low granularity. You can use Power Query to generate Date and Time table: It’s Just a Matter of Time: Power BI Date & Time Dimension Toolkit

See a similar thread below:

https://stackoverflow.com/questions/41290418/how-to-include-time-in-date-hierarchy-in-power-bi

Regards,

[Mi2n]

I thought that you said you know how to create Date column based on the link you provided. Use the same method mentioned in the link to create a calendar table and then create two new columns for Hour and Second using the formula that I gave.