Calendar with date and time (HH:MM:SS)

[kadapavel]

Hello

I'm trying to have calendar with "YYYY,MM,DD" and "HH:MM:SS"

First part is done with 

Date = 
ADDCOLUMNS (
CALENDAR (DATE(2016,1,1), DATE(2018,12,31)),
"DateDate"     , FORMAT ( [Date], "MM/DD/YYYY" ),
"Year"              , FORMAT( [Date], "YYYY" ),
"Monthnumber"       , FORMAT ( [Date], "MM" ),
"YearMonthnumber"   , FORMAT ( [Date], "YYYY/MM" ),
"YearMonthShort"    , FORMAT ( [Date], "YYYY/mmm" ),
"MonthNameShort"    , FORMAT ( [Date], "mmm" ),
"MonthNameLong"     , FORMAT ( [Date], "mmmm" ),
"DayOfWeekNumber"   , WEEKDAY ( [Date] ),
"DayOfWeek"         , FORMAT ( [Date], "dddd" ),
"DayOfWeekShort"    , FORMAT ( [Date], "ddd" ),
"Quarter"           , "Q" & FORMAT ( [Date], "Q" ),
"YearQuarter"       , FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" )
)

Second part I'm stugling with

Who can help to make calendar including hours, minutes and seconds?

BR

Pavel

[v-sihou-msft · Accepted solution]

@kadapavel

I highly recommend you make Date calendar table and Time part table separated. You can imagine that if you want to get "hh:mm:ss" for every single date, you will get a 24*60*60 times huge table than your existing Date table. So just Create a Time table with Hour, Minute, Seconds, etc columns in your data model. 

Please also see this article: 

Data Import Best Practices in Power BI

Regards,