Introduction to DAX (Quick Overview)

-

This is just an overview of DAX language. We will begin calculations and extensive analysis on my next post.Enjoy.

What is DAX?:

Data Analysis Expression(DAX) is a Functional Language currently used in Power BI Desktop ,Analysis Services Tabular and Power Pivot for Excel. It is a collection of functions that can be used to calculate and return one or more values. In DAX, functions can contain other, nested functions and value references depending on your model and key business questions to be answered. DAX includes some of the functions used in Excel formulas plus other functions designed specifically to work with relational data and perform dynamic aggregations.

Why DAX?:

The difficult questions raised facing a business or an organization can be simplified using DAX, to shed more light into your data. Learning how to create effective DAX formulas will help you get the most out of your data and be able to solve real business problems.

What is DAX used for?:

1. Calculated Columns: This DAX model operates in the context of the current row across that table. Which also indicates,you cannot directly access the values of other rows. You must know, all calculated columns occupy space in memory and are computed during table processing.(calculated column uses your RAM).

2. Calculated Measures: This DAX model is used to aggregate values from many rows in a table. A measure is evaluated in the context of the cell evaluated in a report or in a DAX query on like calculated column computed at the row level within the table it represents.

What are DAX's Data types?:

1. Whole Number.

2. Decimal Number.

3. Currency.

4. True/False.

5. Text.

6. Date.

7. Binary.

Other important DAX concepts will be discussed in my next post.

Comments

  1. Kale Co JakimOctober 4, 2026 at 7:11 AM

    This is a helpful introduction to DAX and its role in business intelligence. Understanding the difference between calculated columns and measures is especially important when building reports and analyzing data in Power BI. DAX functions make it possible to answer business questions through calculations and dynamic aggregations.

    Learning DAX becomes easier when you understand the fundamentals of data analysis and how to interpret information from different datasets. The Data Analysis Course can help develop the analytical skills needed to identify trends, evaluate business performance, and turn raw data into meaningful insights.

    ReplyDelete
  2. Kale Co JakimOctober 4, 2026 at 7:11 AM

    Presenting the results clearly is another essential part of effective reporting. The Data Visualization Course can help learners understand how to communicate analytical findings through charts and dashboards, complementing DAX calculations and making business reports easier to interpret.

    ReplyDelete

Post a Comment

Popular posts from this blog

Bringing Kubernetes to Windows Server apps(Google Cloud Platform)

-
Image
Firstly, before we begin. For those that don't already know. What is Google Kubernetes Engine ?: GKE is an enterprise-grade platform for containerized applications, including stateful and stateless, AI and ML, Linux and Windows, complex and simple web apps, API, and backend services. Leverage industry-first features like four-way auto-scaling and no-stress management. Optimize GPU and TPU provisioning, use integrated developer tools, and get multi-cluster support from SREs. Now that we know GKE, the purpose of this post is about running Windows Server apps as containers on Kubernetes, where you get many of the benefits that Linux applications have enjoyed for years. Running your Windows Server containers on GKE can also save you on licensing costs, as you can pack many Windows Server containers on each Windows node. In the beta release of Windows Server container support in GKE (version 1.16...
Read more

Apache Cassandra in the Cloud : Amazon Keyspaces and Datastax Astra

-
Image
Apache Cassandra is a distributed database that delivers the high availability, performance, and linear scalability today’s most demanding applications require.  It offers operational simplicity and effortless replication across cloud service providers, data centers, and geographies, and it can handle petabytes of information  and thousands of concurrent operations per second across hybrid cloud environments. The arrival of managed cloud services to Cassandra is key to making this high-performance, highly-scaled distributed database accessible to a wider audience.  Cassandra has long been known for its performance and scale, but never for its ease of use. Given those hurdles,  But, as the popularity of AWS's DynamoDB service shows, there is strong demand for distributed databases. The fact is, managed cloud services eliminate, patches, maintenance, and upgrades.  The management API wraps an abstraction layer around the JMX (Java Management Extensions)  tha...
Read more

Cloud Computing : AWS vs MS Azure vs Google Cloud Platform

-
Image
My major Cloud Computing players; AWS, Azure and Google. Choosing one is the most difficult task for those that wants to enter and grow in the cloud world. With the continuous growing importance of Cloud Computing services nowadays, demand is on the high side. Cloud service providers supply resources like database, applications, and storage over the internet to reduce the cost of managing and maintaining your IT systems. Services/Products offered: 1. Software as a Service (SaaS): Software as a service is a software licensing and delivery model in which software is licensed on a subscription basis and is centrally hosted. 2. Infrastructure as a Service (IaaS): Infrastructure as a service refers to online services that provide high-level APIs used to dereference various low-level details of underlying network infrastructu...
Read more