TODAY(): TODAY() : Current date per model timezone

NOW(): NOW() : Current date & time

YEAR(): YEAR( Orders[Order Date] ) : Extract year component

MONTH(): MONTH( Orders[Order Date] ) : Month number

DAY(): DAY( Orders[Order Date] ) : Day of month

HOUR(): HOUR( Orders[Order DateTime] ) : Hour part

EOMONTH(): EOMONTH( Orders[Order Date],0 ) : Last day of month offset

DATE(): DATE( 2025,4,23 ) : Construct date from Y,M,D

DATEVALUE(): DATEVALUE( Orders[DateText] ) : Convert text to date

DATEDIFF(): DATEDIFF( Orders[Order Date], Orders[Ship Date], DAY ) : Difference between two dates

DATEADD(): DATEADD( Dates[Date], -1, YEAR ) : Shift date column by interval

SAMEPERIODLASTYEAR(): SAMEPERIODLASTYEAR( Dates[Date] ) : Parallel period previous year

PARALLELPERIOD(): PARALLELPERIOD( Dates[Date], -3, MONTH ) : Parallel offset period

TOTALYTD(): TOTALYTD( SUM( Sales ), Dates[Date] ) : Year-to-date running total

WEEKNUM(): WEEKNUM( Orders[Order Date] ) : ISO week number