00 DAX Gists

// This gist containt useful pieces of DAX code

01 Power BI Date Table

Date Table = 

VAR MinYear = YEAR ( MIN ( 'Table Name'[Table Column] ) )
VAR MaxYear = YEAR ( MAX ( 'Table Name'[Table Column] ) )
RETURN

ADDCOLUMNS (
    FILTER(
        CALENDARAUTO( ),
        AND(
            YEAR([Date])>=MinYear,
            YEAR([Date])<=MaxYear
        )
    ),
    "Year", YEAR ( [Date] ),
    "Month Number", MONTH ( [Date] ),
    "Year-Month",YEAR([Date])&"-"&if(LEN(MONTH([Date]))=1,"0"&MONTH([Date]),MONTH([Date])),
    "YY-MM", FORMAT([Date], "YY-MM"),
    "YYMM", FORMAT([Date], "YYMM"),
    "Weekday", FORMAT ( [Date], "dddd" ),
    "Weekday number", WEEKDAY( [Date] ),
    "Year-Quarter",Year([Date])& " Q" & TRUNC ( ( MONTH ( [Date] ) - 1 ) / 3 ) + 1,
    "FY-YY", IF(MONTH([Date])>=7, "FY-"&RIGHT(YEAR([Date]) + 1,2) , "FY-"&RIGHT(YEAR([Date]),2)),
    "FYYYY",IF(MONTH([Date])>=7, YEAR([Date]) + 1,YEAR([Date])),
    "After Today", IF([Date] > TODAY(), TRUE(), FALSE())
)

02 Rolling Sum

Rolling sum = 

VAR MaxDate = MAX('Date Table'[Date])

RETURN

CALCULATE(
    [Measure], 
    'Date Table'[Date] <= MaxDate,
    ALL('Date Table')
)