What are DAX formulas in Excel’s Power Pivot and how do they differ from regular Excel formulas?

Question

Microsoft Excel — Hard

What are DAX formulas in Excel’s Power Pivot and how do they differ from regular Excel formulas?

Accepted Answer

DAX formulas in Excel's Power Pivot operate on entire columns and tables, differing from regular Excel formulas. The correct answer highlights this distinction, noting functions like CALCULATE and RELATED. Incorrect options misrepresent DAX as using SQL or Python syntax, or being identical to standard Excel formulas.