Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |