What is ADDCOLUMNS? · Ultra Transcenders glossary

A DAX function that takes a table and hands it back with extra computed columns appended, working out each new expression row by row while keeping every existing column.

In the Ultra Transcenders books

DP-600 PL-300

Each book explains ADDCOLUMNS in context, with comparison tables and the common traps.

Terms in this definition

DAX
Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.
Event
Table in Log Analytics where entries from Windows event logs are kept.

See ADDCOLUMNS in the full glossary