Voiced by Amazon Polly |
Overview
DAX is a programming language used to create calculated columns, measures, and custom tables through Power BI by Microsoft.
Pioneers in Cloud Consulting & Migration Services
- Reduced infrastructural costs
- Accelerated application deployment
Introduction
- DAX is an acronym for Data Analysis Expressions. DAX is used as expressions and formulas for calculating and predicting data, as it can be any data.
- DAX can also be called Functional Language in Power BI. That means we can put every piece of code in a function. Also, we can use conditional statements, variables, operators and nested functions, etc. These all can be a part of DAX expression.
- DAX formulas can also be used in measures, calculated columns, and calculated tables.
Ex. Sum of Sales = SUM (Orders [Sales])
- In the above formula
Sum of Sales – is the name of the measure.
Orders – is the name of the table.
SUM – is a built-in function.
Sales – is the name of the field in the Orders table.
Measures
- These are dynamic calculation formulas where the values are changed depending on context. It is mainly used in reporting.
- Some predefined formulas, such as SUM, DIVIDE, and COUNT, can be used in a measure.
Ex. Total Sales = SUM (Sales [Sales Amount])
Calculated Columns
- You can add any number of columns to an existing table using the Calculated Columns It’s only possible to add columns in the model designer.
- “Qtr.” & Quarter (Calendar [Date])
Calculated Tables
- It is called a computed The main use of a calculated table is instead of querying and loading values into your new table’s columns from a source, here DAX formulas define the table’s values.
- It also supports relationships between different tables. These can be re-calculated if any data in the tables are updated.
Some useful DAX Functions
Types of Functions in DAX
Benefits of DAX
- With the help of DAX, Power BI developers can create visualization and reports, providing deeper insight into the data.
- It mainly solves business problems by predicting the data from the data model using different functions in formulas.
- Easy to learn.
- You can make smarter to your dashboard.
- Speed up your dashboard by using DAX measures.
- DAX can be used in tabular Microsoft products like Powe BI, Microsoft Analysis Services, and Microsoft Power Pivot for Excel.
Conclusion
DAX supports various types of data for predicting and analyzing the data. Before getting into Power BI Desktop Application, you should know in detail all the concepts of DAX Measures described in this blog. You don’t need to be a programmer to learn these basic concepts of DAX.
Empowering organizations to become ‘data driven’ enterprises with our Cloud experts.
- Reduced infrastructure costs
- Timely data-driven decisions
About CloudThat
CloudThat is a leading provider of Cloud Training and Consulting services with a global presence in India, the USA, Asia, Europe, and Africa. Specializing in AWS, Microsoft Azure, GCP, VMware, Databricks, and more, the company serves mid-market and enterprise clients, offering comprehensive expertise in Cloud Migration, Data Platforms, DevOps, IoT, AI/ML, and more.
CloudThat is the first Indian Company to win the prestigious Microsoft Partner 2024 Award and is recognized as a top-tier partner with AWS and Microsoft, including the prestigious ‘Think Big’ partner award from AWS and the Microsoft Superstars FY 2023 award in Asia & India. Having trained 850k+ professionals in 600+ cloud certifications and completed 500+ consulting projects globally, CloudThat is an official AWS Advanced Consulting Partner, Microsoft Gold Partner, AWS Training Partner, AWS Migration Partner, AWS Data and Analytics Partner, AWS DevOps Competency Partner, AWS GenAI Competency Partner, Amazon QuickSight Service Delivery Partner, Amazon EKS Service Delivery Partner, AWS Microsoft Workload Partners, Amazon EC2 Service Delivery Partner, Amazon ECS Service Delivery Partner, AWS Glue Service Delivery Partner, Amazon Redshift Service Delivery Partner, AWS Control Tower Service Delivery Partner, AWS WAF Service Delivery Partner, Amazon CloudFront Service Delivery Partner, Amazon OpenSearch Service Delivery Partner, AWS DMS Service Delivery Partner, AWS Systems Manager Service Delivery Partner, Amazon RDS Service Delivery Partner, AWS CloudFormation Service Delivery Partner, AWS Config, Amazon EMR and many more.
FAQs
1. How many types of DAX measures are divided?
ANS: – There are two types of DAX measures implicit measures and explicit measures.
2. Why is the Explicit measure type much better than the implicit measure type?
ANS: – Because Explicit measure type provides features like Control, Reuse, and Connected Reports.

WRITTEN BY Sridhar Andavarapu
Sridhar Andavarapu is a Senior Research Associate at CloudThat, specializing in AWS, Python, SQL, data analytics, and Generative AI. With extensive experience in building scalable data pipelines, interactive dashboards, and AI-driven analytics solutions, he helps businesses transform complex datasets into actionable insights. Passionate about emerging technologies, Sridhar actively researches and shares insights on AI, cloud analytics, and business intelligence. Through his work, he aims to bridge the gap between data and strategy, helping enterprises unlock the full potential of their analytics infrastructure.
Comments