Data Analysis and data modelling made easy with Data Analysis eXpressions. DAX can be used in Power BI, Power Pivot and Analysis Services.
Analyse and Model your data with in Power BI, Excels Power Pivot and Analysis Services with Data Analysis eXpressions.
This is a hands on course
In the first section of this course you will be introduced to the use of the most common DAX expressions, such as SUM and SUMX, COUNT, ROUND, DIVIDE, MIN, MAX, IF Statements, TEXT expressions, Variables and More
In the next section of this course you will learn the fundamentals of how DAX works. This section will include both theory and examples and it is of utmost importance that you understand how DAX works. We will discuss Row context and Filter context, ALL, FILTER, RELATEDTABLE, CALCULATE, EARLIER, Relationships and much more.
In the third section of this course you will learn about Time Intelligence and Date Tables. We will look at expressions such as TOTALYTD, SAMEPERIODLASTYEAR, DATESADD, DATESBETWEEN, CALENDERAUTO, and we will explore how many of these functions work using CALCULATE
Each section of this course contains Activities to complete. These Activities are of utmost importance. When it comes to learning DAX, practice is a must.
There are two types of calculations in DAX. Calculated Columns and Measures. We will look at both of these in this video
learn about SUM and SUMX, be introduced to RELATED and iterators
learn COUNT and COUNTX and see how calculated columns and measures differ, and learn when it is best to use each
When working with the Data type Currency in DAX, you need to ensure that all of the values are to the correct decimal place, for this you can use ROUND
the DAX DIVIDE function will allow you deal with errors when dividing one value by another, Learn how to use DIVIDE in this video.
Are you familiar with the use of "" to get a blank in Excel? Well in DAX you need to use the BLANK expression to ensure that your blank is of the correct data type
Related and related table will allow you take values from tables joined by relationships. In this video you will be introduced to related table and will we will at related in more detail
If you are looking for the minimum value or the maximum value then DAX MIN and MAX expressions are required. This video includes the updated DAX syntax for MAX in versions 2016 and after, as well as the original syntax.
MINX and MAXX are also covered in this video
In this video you will be introduced to a number of iterators and pairs
learn how to carry out an IF statement in DAX
Learn how to create a Variable to be used in DAX functions and expressions
Learn how you can use the DAX SWITCH expression to replace nested IF statements
There are many TEXT expressions available in DAX, Expressions that will also you format, clean and extract data from TEXT. In this video we will cover many of these TEXT expressions
An overview of section 1.
Learn to use DAX EARLIER expression
CALCULATE is known as one of the most powerful functions in DAX. Find out why in this video
Learn to use CALCULATE with two filters
a quick overview of what to expect in this section on DAX Time Intelligence
learn how to use DAX to create a DATE table, which is used for time intelligence functions
Learn how to address multiple date columns and tables when using DAX
in some user interfaces you need to mark a date table as a date table. Don't forget to do this
In this video you will learn how to use DAX TOTALYTD, TOTALQTD and TOTALMTD expressions
Following on from the previous lesson, in this video you will learn how these time intelligence functions work using Calculate.
Sometimes you need to show same period last year, with dax time intelligence this is rather easy
learn more about how time intelligence works using datesadd
Learn how to calculate the overall total ignoring any time period
Paula is a Qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management,Process improvement, Internal Audit, Group accountant, Operations management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has Udemy courses for those wishing to up skill, especially in the area of Spreadsheets, Bookkeeping and Accounting.
Now an E-learning Educator 5+ years, Paula also has a focus on E-learning and online teaching. Drawn from her online teaching experience,Paula has a number of courses available to online teachers to help bridge the skills gap for those that teach or wish to teach online.