Can you explain what DAX is?
💡 Model Answer
DAX, or Data Analysis Expressions, is a formula language used in Microsoft Power BI, Power Pivot, and SQL Server Analysis Services (SSAS) Tabular models. It is similar to Excel formulas but designed for relational data and columnar models. DAX allows you to create calculated columns, measures, and calculated tables. For example, you can write a measure to calculate total sales: TotalSales = SUM(Sales[Amount]). DAX supports functions for aggregation, filtering, time intelligence, and context transition, enabling powerful business intelligence calculations. It is essential for building dynamic reports and dashboards in Power BI.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.
Get Assisting AI — Starts at ₹500