98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPower BI DAX
Face to face / Virtual public schedule & onsite training. Restaurant lunch included at STL venues.
From £460 List price £700
- 1 day Instructor-led
- Courses never cancelled
- Restaurant lunch
Syllabus
Who 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
Prices & Dates
What you get
"What do I get on the day?"
Arguably, the most experienced and highest motivated trainers.
Face-to-face training
Training is held in our modern, comfortable, air-conditioned suites.
Modern-spec IT, fully networked with internet access
Lunch, breaks and timing
A hot lunch is provided at local restaurants near our venues:
- Bloomsbury
- Limehouse
Courses start at 9:30am.
Please aim to be with us for 9:15am.
Browse the sample menus and view joining information (how to get to our venues).
Refreshments
Available throughout the day:
- Hot beverages
- Clean, filtered water
- Biscuits
Virtual training
Regular breaks throughout the day.
Learning tools
In-course handbook
Contains unit objectives, exercises and space to write notes
Reference material
Available online. 100+ pages with step-by-step instructions
24 months access to Microsoft trainers
Your questions answered on our support forum.
Training formats & Services
Training Formats & Services
|
Testimonials
Humatica
Lucas Lasagna Del Val,
Business Analyst
Great course overall - good pace, good knowledge and good cover of topics.
Could dive into more challenging use of DAX as the few people that take this course are generally already slightly knowledgeable on PowerBI.
Power BI DAX
LCR Property
Nicola Shaw,
AP & Treasury Manager
There is nothing - it was brilliant!
Power BI DAX
Arup
Helen Dines,
Supervisor
Jens is very knowledgeable and enthusiastic, the course was great and ran at the right speed and covered everything would have wanted it to
Power BI DAX
Learning & Development Resources
Blog
- 8 Major Benefits of Microsoft Power BI You Must Know
- Power BI – What is DAX?
- Power BI – Use Variables to Improve Your DAX Formulas
- Power BI’s Mysterious Calculate Function: 1 – Row Context
- Power BI’s Mysterious Calculate Function 2: Filter Context
- Power BI Mysterious Calculate Function 3: Time Intelligence
- Power BI DAX – the mysterious Calculate function 4 – tricks
- Power BI – Dynamic text for detailed reports 1: text boxes
- Power BI – Advanced options to make forecasting models
- Power BI –Power Query M functions versus DAX
Infographics
Thanks. Your download will begin shortly.
Please help us
Share or create a link to this manual today!
Just follow these simple instructions...