Power BI DAX
- 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.
What to expect
- Courses never cancelled .
- Restaurant lunch .
- Last minute rescheduling .
- 24 month delegate support forum .
- Face-to-Face and Online Instructor led .
- And more... .
Upcoming start dates
Upcoming start dates
Suitability - Who should attend?
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.
Training Course Content
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/SUMXCOUNT/COUNTX/DISTINCTCOUNT/COUNTROWS
AVERAGE/AVERAGEX
MAX/MAXX
MIN/MINX
Logical functions
IFSWITCH
AND/OR
Filter functions
CALCULATERELATED
RELATEDTABLE
FILTER
HASONEVALUE
VALUES
ALL
USERELATIONSHIP
ISFILTERED
Time-intelligence functions
DATEADDSAMEPERIODLASTYEAR
EOMONTH
DATESBETWEEN
TOTALMTD/TOTALQTD/TOTALYTD
DATESMTD/DATESQTD/DATESYTD
PREVIOUSDAY/ PREVIOUSMONTH/ PREVIOUSQUARTER/ PREVIOUSYEAR
Other useful functions
LOOKUPVALUEEARLIER
COMBINEVALUES
SUMMARIZE
ROLLUP
DIVIDE
TOPN
FIRSTDATE
LASTDATE
Understand the use of parameter tables
What is a parameter tableHow to use a parameter table in DAX
The DAX Studio Application Demonstration
Benefits of writing DAX and testing DAX in DAX StudioVariables
What is a variable and what is the benefit using variablesDebug code
Introduction to calculated tables in Power BI Desktop
What is calculated tablesCreate Calendar table
The UNION function
Expenses
List price £700, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.
Request information - obligation free
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Reviews by course attendees
Average rating 4.9
The only thing I can think of is making the learning slightly more active. Perhaps more tasks could be assigned to the learner during the course.
This was a great course; its given me exactly what I wanted a complete overview of DAX within Power BI. I feel a lot more confident about using it back in the office.
STL
Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...
Most useful topic: Forecast and custom filtering