What are the DAX operators in power bi

This recipe explains what are the DAX operators in power bi

Recipe Objective - What are the DAX operators in Power BI?

The Data Analysis Expression (DAX) language uses operators to create expressions that compare values, perform arithmetic calculations, or work with strings.

Following are the types of operators:

Arithmetic operators perform basic mathematical operations such as addition, subtraction, or multiplication; combine numbers, and produce numeric results.

Comparison operators - You can compare two values with the following operators. When two values are compared using these operators, the result is a logical value, either TRUE or FALSE.

Text concatenation operator - Use the ampersand (&) to join, or concatenate, two or more text strings to produce a single piece of text.

Logical operators - Use logical operators (&&) and (||) to combine expressions to produce a single result.

Arithmetic operators -

+ (plus sign) - Addition
Example => 9+3

– (minus sign) - Subtraction or sign
Example => 9-3

* (asterisk) - Multiplication
Example => 9*3

/ (Forward slash) - Division
Example => 9/3

Comparison operators -

= - Equal to
Example => [Name] = "Roy"

== - Strict Equal to
Example => [Name] == "Roy"

> - Greater than
Example => [Salary] > 100000

>= - Greater than equal to
Example => [Salary] >= 100000

< - Less than
Example => [Salary] < 100000

<= - Less than equal to
Example => [Salary] <= 100000

Text concatenation operator -

& (ampersand) => Concatenation
Example => [First Name] & ',' & [Last Name]

Logical operators -

&& (double ampersand) - Creates an AND condition between two expressions
Example => [Name] = "Roy" && [Salary] > 10000

|| (double pipe symbol) - Creates an OR condition between two expressions
Example => [Name] = "Roy" || [Salary] > 10000

In this way, we can use DAX operators in Power BI.

Download Materials

What Users are saying..

profile image

Ameeruddin Mohammed

ETL (Abintio) developer at IBM
linkedin profile url

I come from a background in Marketing and Analytics and when I developed an interest in Machine Learning algorithms, I did multiple in-class courses from reputed institutions though I got good... Read More

Relevant Projects

Classification Projects on Machine Learning for Beginners - 1
Classification ML Project for Beginners - A Hands-On Approach to Implementing Different Types of Classification Algorithms in Machine Learning for Predictive Modelling

Natural language processing Chatbot application using NLTK for text classification
In this NLP AI application, we build the core conversational engine for a chatbot. We use the popular NLTK text classification library to achieve this.

MLOps Project on GCP using Kubeflow for Model Deployment
MLOps using Kubeflow on GCP - Build and deploy a deep learning model on Google Cloud Platform using Kubeflow pipelines in Python

Deep Learning Project- Real-Time Fruit Detection using YOLOv4
In this deep learning project, you will learn to build an accurate, fast, and reliable real-time fruit detection system using the YOLOv4 object detection model for robotic harvesting platforms.

NLP Project to Build a Resume Parser in Python using Spacy
Use the popular Spacy NLP python library for OCR and text classification to build a Resume Parser in Python.

Build an Image Classifier for Plant Species Identification
In this machine learning project, we will use binary leaf images and extracted features, including shape, margin, and texture to accurately identify plant species using different benchmark classification techniques.

MLOps using Azure Devops to Deploy a Classification Model
In this MLOps Azure project, you will learn how to deploy a classification machine learning model to predict the customer's license status on Azure through scalable CI/CD ML pipelines.

Build a Speech-Text Transcriptor with Nvidia Quartznet Model
In this Deep Learning Project, you will leverage transfer learning from Nvidia QuartzNet pre-trained models to develop a speech-to-text transcriptor.

PyTorch Project to Build a GAN Model on MNIST Dataset
In this deep learning project, you will learn how to build a GAN Model on MNIST Dataset for generating new images of handwritten digits.

LLM Project to Build and Fine Tune a Large Language Model
In this LLM project for beginners, you will learn to build a knowledge-grounded chatbot using LLM's and learn how to fine tune it.