Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kadapavel
Helper II
Helper II

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

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

1 ACCEPTED SOLUTION
v-sihou-msft
Employee
Employee

@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,

View solution in original post

1 REPLY 1
v-sihou-msft
Employee
Employee

@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,

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.