DAX (Data Analysis Expressions)
💡 Quick Definition: A formula expression language used in Microsoft Power BI, Analysis Services, and Power Pivot in Excel.
Detailed Explanation & Workplace Application
DAX is a collection of functions, operators, and constants that can be used in a formula to calculate and return one or more values. Unlike standard Excel formulas that refer to cell ranges, DAX operates over entire tables and columns, dynamically adjusting calculations based on the active filter context.
Practical Syntax / Framework Formula
Total Sales India =
CALCULATE(
SUM(Sales[Revenue]),
DimGeography[Country] = "India",
Sales[Year] = 2026
)