DAX is a library of functions and operators used in Power Pivot and Power BI to build custom calculations and data models.
Wypróbuj z SIDAX (Data Analysis Expressions) is a formula language designed for relational data modeling and advanced analytics. It allows users to create calculated columns, measures, and tables by performing aggregations and logical operations on data stored in tabular models.
A simple DAX measure to calculate total sales: Total Sales = SUM(Sales[Amount]).
While Excel formulas operate on cell ranges, DAX formulas operate on entire columns or tables, making them more efficient for large datasets and relational models.