# Course details

### Location: This course is run virtually online.

DAX, or Data Analysis Expressions, is the language that’s used to create formulas in Power BI Desktop that extend our data model. DAX gives us the ability to create additional information at runtime so that we can quickly and easily generate new information beyond the information that’s in our Power BI model already.

If you already know how to build data models in Power BI Desktop, learning DAX is a logical next step, because there are things that we can do with DAX that we can’t do as easily or at all without it. This course is designed to explore the capabilities of DAX within Power BI Desktop.

### Prerequisite

This is not a beginner’s course in Power BI. Our assumption is that you know some things before attending. For example, you know how to connect to data sources in Power BI Desktop, and once you have, you know how to add and remove columns, and change data types. If not, we recommend attending either the 3-hour Power BI Introduction or 1-day Power BI Introduction course first.

## Learning objectives

### Set Up a Data Model

• Data modelling: the basics
• Connect to a source file
• Check relationships

### DAX Aggregate Functions

• DAX filter context
• Step-by-step measure calculation
• Basic maths and stats functions
• Create a SUM measure
• Understanding DAX syntax
• Display the measure in a matrix
• Aggregate COUNT measure
• The COUNTROWS measure
• Check data with COUNTBLANK
• Create a DISTINCTCOUNT measure

### Edit a Measure

• Format a measure
• Edit and delete a measure
• Make DAX easier to read
• The quick measure option
• Move a measure

### Measures and Calculated Columns

• Explicit vs. implicit measures
• Create a measure with operators
• Using DIVIDE for percentage

### The Logical and Filter Measures

• Logical functions IF, AND, and OR
• Create a FIND calculated column
• Create an IF calculated column
• Using more than two conditions
• Best practices
• Calculated columns vs. measures
• Common function categories

### The SWITCH Function

• SWITCH with nested TRUE

### Text Functions

• Basic text functions
• The CONCATENATE function
• Nest LEFT inside UPPER
• Nest SEARCH inside LEFT

### The CALCULATE Measure

• Anatomy of CALCULATE
• Use CALCULATE as a filter

### The ALL Measure

• Anatomy of ALL
• Create an ALL measure
• Use ALL as a filter
• Use ALL in percentage measures
• Pass a table or column to ALL

### The RELATED Function

• Create a RELATED function

### Iterators and Row Context

• Iterator “X” measure SUMX
• Anatomy of iterators and row context
• A closer look at SUMX
• Create a RANKX

### Date and Time Functions

• Basic date and time functions
• Create a DATEDIFF function
• The EOMONTH function

### Time Intelligent Measures

• Compare historical monthly data
• Create TOTALYTD/QTD/MTD measures
{"ft_lang_label":"__label__en","ft_lang_prob":0.78900474,"math_prob":0.7972336,"size":2967,"snap":"2020-45-2020-50","text_gpt3_token_len":689,"char_repetition_ratio":0.15761054,"word_repetition_ratio":0.0,"special_character_ratio":0.2082912,"punctuation_ratio":0.052,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.98568594,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2020-11-29T06:45:26Z\",\"WARC-Record-ID\":\"<urn:uuid:49692e48-4731-4b59-8cce-f823fbf72547>\",\"Content-Length\":\"81937\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:03582554-aaaa-41b6-bcd4-1327d134877f>\",\"WARC-Concurrent-To\":\"<urn:uuid:e18fe0da-be1a-49bd-a419-8ee2e6256bfe>\",\"WARC-IP-Address\":\"77.72.1.20\",\"WARC-Target-URI\":\"https://powerbicourses.co.uk/power-bi-dax-measures/\",\"WARC-Payload-Digest\":\"sha1:CTA52IVTOLQCQRMYHKVJB5VA5RTX6XXH\",\"WARC-Block-Digest\":\"sha1:GCB6NV6WFTEVSMGUMJL2DJJKOAFTNAIH\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2020/CC-MAIN-2020-50/CC-MAIN-2020-50_segments_1606141197278.54_warc_CC-MAIN-20201129063812-20201129093812-00531.warc.gz\"}"}