HOME
 

Power BI DAX

STL
Course summary
1 day
English
Nationwide
Corporate Training for Teams
STL courses

Power BI DAX



Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... 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.

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/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
ALLEXCEPT
USERELATIONSHIP

Time-intelligence functions

DATEADD
SAMEPERIODLASTYEAR
ENDOFMONTH/ENDOFQUARTER/ENDOFYEAR
DATESBETWEEN
TOTALMTD/TOTALQTD/TOTALYTD
PREVIOUSDAY/ PREVIOUSMONTH/ PREVIOUSQUARTER/ PREVIOUSYEAR

Other useful functions

LOOKUPVALUE
EARLIER

Understand the use of parameter tables

What is a parameter table
How to use a parameter table in DAX

The DAX Studio Application

Benefits of writing DAX in DAX Studio

Variables

What is a variable and what is the benefit using variables
Step DAX code
Debug code

Introduction to calculated tables in Power BI Desktop

What is calculated tables
Create Calendar table
The UNION function

Basic DAX Queries

Introduction to DAX queries

Expenses



Prices from £2000. Promotional rates often available the further ahead you book. Contact us for quote.

Provider: STL

STL - Microsoft Training

STL - Helping businesses deliver productivity and efficiency gains

Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....


Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Power BI DAX.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award

customer-outreach-badge-2019

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.

Contact information for STL

STL

Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number
www.stl-training.co.uk

Request information

Find out more about this Power BI DAX course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here