CURRENCY() : CURRENCY( Sales ) : Convert numeric to currency data type

FORMAT() : FORMAT( Date, "MMM yyyy" ) : Custom format string

UNICHAR() : UNICHAR( 128512 ) : Unicode character

UNICHAR() : UNICHAR( 128525 ) : Multiple expressions for icons

PATHLENGTH() : PATHLENGTH( HierarchyPath ) : Count items in PATH

DATATABLE() : DATATABLE("Col",STRING,{ {"A"},{"B"} }) : Inline static table

GENERATESERIES() : GENERATESERIES(1,10,1) : Create number table

ADDMISSINGITEMS() : ADDMISSINGITEMS( SUMMARIZE(...) ) : Ensure all combinations appear

CONTAINSROW() : CONTAINSROW( {"East","West"}, Region[Name] ) : Check column value in set

MATCHBY() : MATCHBY( Customers[Year], Customers[Segment] ) : Define drive columns for calculation
group

TOCSV() : TOCSV( VALUES(Product[Category]) ) : Concatenate list as CSV text

ISO.CEILING() : ISO.CEILING( Sales, 5 ) : Round up per ISO rule

COMBINEVALUES() : COMBINEVALUES("-", ColumnA, ColumnB) : Create composite key string

SELECTEDVALUE() : SELECTEDVALUE( Date[Year] ) : Return single selected value or blank

GROUPBY + CURRENTGROUP(): GROUPBY( Sales, Sales[Region], "Avg", AVERAGEX(CURRENTGROUP(),
Sales[Sales]) ) : Nested calculations within grouping

ROWS() : ROWS( Products ) : Alias COUNTROWS

DATETIME() : DATETIME(2025,4,23,10,30,0) : Create date & time scalar

STDEV.P() : STDEV.P( Sales ) : Population stdev scalar

RANK.EQ() : RANK.EQ( [Sales] ) : Excel style rank (2024 new)

RANK.AVG() : RANK.AVG( [Sales] ) : Average ranking for ties