Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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,
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,
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |