PL:300: Applying the Dax Formula Language in Power BI
- Offered bySkillsoft
PL:300: Applying the Dax Formula Language in Power BI at Skillsoft Overview
Duration | 1 hour |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Go to Website |
Credential | Certificate |
PL:300: Applying the Dax Formula Language in Power BI at Skillsoft Highlights
- Earn a digital badge after completion of course from Skillsoft
PL:300: Applying the Dax Formula Language in Power BI at Skillsoft Course details
Discover the key concepts covered in this course
Import multiple related tables into power bi desktop
Use the dax language to calculate a sum of values based on an operation performed on raw data
Compute the average of a value derived from the data in a table
Use the blank function to generate blank values
Perform a variety of count operations using the different count functions available in dax
Perform operations on a subset of data in a table
Define a dax formula using nested if function calls
Set the operations to be performed in different scenarios using the switch function
In this course you will learn how to conduct several data analysis operations using the DAX formula language
Learners Learn how to generate and work with blank data in DAX
Explore a variety of counting functions, ranging from simple counts of values to conditional counts based on filters
Upon course completion, you'll know how to use DAX to calculate values and reference table data in Power BI
PL:300: Applying the Dax Formula Language in Power BI at Skillsoft Curriculum
Course Overview
Loading Fact and Dimension Tables
Calculating Sums with an Expression
Using the AVERAGEX Function
Generating Blank Data
Applying Different Count Functions
Creating Filtered Tables
Using Nested DAX Functions
Using the SWITCH Function
Course Summary