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.
Create a calendar with DAX in Power BI. Generate/ Create calendars in DAX using CALENDAR() and/or CALENDARAUTO().
Link to Power BI file: http://gofile.me/2kEOD/NlzDFymMX
Do you want to know more about calendars? We have an entire playlist for you to watch here:
https://www.youtube.com/playlist?list=PLDz00l_jz6zwrYvfWcWITHMiZf3G-HDq7
DAX expression:
Date = ADDCOLUMNS ( CALENDAR (DATE(2000,1,1), DATE(2025,12,31)), "DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ), "Year", YEAR ( [Date] ), "MonthNo", FORMAT ( [Date], "MM" ), "YearMonthNo", FORMAT ( [Date], "YYYY/MM" ), "YearMonth", FORMAT ( [Date], "YYYY/mmm" ), "MonthShort", FORMAT ( [Date], "mmm" ), "MonthLong", FORMAT ( [Date], "mmmm" ), "WeekNo", WEEKDAY ( [Date] ), "WeekDay", FORMAT ( [Date], "dddd" ), "WeekDayShort", FORMAT ( [Date], "dddd" ), "Quarter", "Q" & FORMAT ( [Date], "Q" ), "YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" )
Calendars in Power Query: https://www.youtube.com/watch?v=-tg0m...
Northwind datasource: https://www.youtube.com/watch?v=k3NMI...
Our Playlists:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l
About us:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact
Connect with us:
Twitter: @curbalen, @ruthpozuelo
Google +: https://goo.gl/rvIBDP
Facebook: https://goo.gl/bME2sB
watch?v=kC3w_KVVabY