DAX DATE TIME Table Example used in Power BI

Leave a reply

Example of using DAX date table in Power BI 

Dates =
VAR MinDate = DATE ( 2017, 1, 1 )
VAR MaxDate = DATE( 2026,1,1)
RETURN
ADDCOLUMNS (
    CALENDAR ( MinDate, MaxDate ),
    "Year", YEAR ( [Date] ),
    "Quarter", "Q" & FORMAT ( [Date], "Q" ),
    "Month", MONTH ( [Date] ),
    "MonthName", FORMAT ( [Date], "MMMM" ),
    "MonthShort", FORMAT ( [Date], "MMM" ),
    "YearMonth", FORMAT ( [Date], "yyyy-MM" ),
    "Day", DAY ( [Date] ),
    "DayOfWeek", WEEKDAY ( [Date], 2 ),
    "DayName", FORMAT ( [Date], "dddd" ),
    "IsWeekend", IF ( WEEKDAY ( [Date], 2 ) > 5, 1, 0 )
)

Show the data table example generated with DAX language