This one day course is ideal for experienced users of Power BI who wish to optimise the speed and efficiency of Power BI through the use of DAX (Data Analysis Expressions) formula language.
DurationWho Is This Course For?
This one day course is ideal for experienced users of Power BI who wish to optimise the speed and efficiency of Power BI through the use of DAX (Data Analysis Expressions) formula language.
Prerequisites
Attended our 2 day Power BI Modelling, Visualisation and Publishing course, or Power Bi users with a basic understanding of DAX.
Benefits
At the end of this course you will have a greater understanding of building DAX functions. You will understand how you can optimise the speed of your measures in your data model and the use of variables to optimise and debug the DAX measures.
Course Syllabus
Introduction to DAX
What is DAX (Data Analysis eXpressions)
Why do we need DAX in Power Bi Desktop
The DAX Structure
The DAX Formatter
Column Calculations versus Measures
Basic DAX functions
SUM/SUMX
COUNT/COUNTX/DISTINCTCOUNT/COUNTROWS
AVERAGE/AVERAGEX
MAX/MAXX
MIN/MINX
Logical functions
IF
SWITCH
AND/OR
Filter functions
Calculate
Related
Relatedtable
Filter
Hasonevalue
Values
All
Userelationship
Isfiltered
Time-intelligence functions
Dateadd
Sameperiodlastyear
Eomonth
Datesbetween
Totalmtd/totalqtd/totalytd
Datesmtd/datesqtd/datesytd
Previousday/ Previousmonth/ Previousquarter/ PreviousyeaR
Other useful functions
Lookupvalue
Earlier
Combinevalues
Summarize
Rollup
Divide
Topn
Firstdate
Lastdate
Understand the use of parameter tables
What is a parameter table
How to use a parameter table in DAX
The DAX Studio Application Demonstration
Benefits of writing DAX and testing DAX in DAX Studio
Variables
What is a variable and what is the benefit using variables
Debug code
Introduction to calculated tables in Power BI Desktop
What is calculated tables
Create Calendar table
The UNION function
We seek to provide an unrivalled value and quality service, enabled by our unique business model. We are excited to announce that we have resumed face-to-face training both on our public schedule and onsite.
We're here to help - from Managing Teams Remotely, using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch, to leadership & development programmes.
The professionalism and performance of our people is fundamental to us. Our company culture brings together individuals that cooperate through trust. Bureaucracy and micro-management are kept to a minimum. No photocopiers exist and only essential paper documents are retained.
Our working relationships are typified by their openness and the common goal to achieve the best performance in our industry, both personally and organisationally. The team enjoys a high level of decision making authority, allowing flexibility and creativity.
By working with individuals that have the passion and integrity to deliver, the management team is freed from policing and able to focus on continuous improvement. Feedback to drive quality development is continuously applied from a 100% client satisfaction sampling system.
An Introduction to Microsoft Power BI. This course takes a look at the core concepts of Power BI and introduces course attendees to report and dashboard creation in Power BI.
The Power BI course provides you with the knowledge and skills required to analyse data with self-service BI, connect to data sources, perform advanced data modelling and shaping, perform advanced analysis, publish and share reports and dashboards, extend access to Power BI, and more.
Microsoft Power BI training is offered by Nexus Human UK. Impact of Nexus Human extends far and wide, helping individuals enhance their career prospects and aiding businesses in achieving their goals.
The primary role of a Data Analyst is to collect, organise and study data to provide business insight. Data analysts are typically involved with managing, cleansing, abstracting and aggregating data, and conducting a range of analytical studies on that data.
Big Data is no more a buzz word in the IT industry’s across the world, rather it is considered as one of the integrated parts of businesses regardless of the type and size of the business. T
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the UK, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore
Saudi Arabia
Egypt
Jordan