PL-300: Applying the DAX Formula Language in Power BI

Microsoft Power BI    |    Beginner
  • 10 videos | 1h 16m 2s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 154 users Rating 4.6 of 154 users (154)
Power BI does the heavy lifting when it comes to analyzing data. One way it does this is through the DAX formula language. By learning how to use this language, you can vastly improve the insights you get from data. Use this course to learn how to conduct several data analysis operations using the DAX formula language. Begin by performing aggregation operations, such as sum and average. 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. Lastly, practice using the IF and SWITCH functions. Upon course completion, you'll know how to use DAX to calculate values and reference table data in Power BI. You'll also be further prepared for the PL-300: Analyzing Data with Microsoft Power BI certification exam.

WHAT YOU WILL LEARN

  • 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
    Summarize the key concepts covered in this course

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course PL-300: Maps, Waterfall Charts, & Scatter Plots in Power BI
Rating 4.5 of 83 users Rating 4.5 of 83 users (83)
Book A Power BI Compendium: Answers to 65 Commonly Asked Questions on Power BI
Course PL-300: Working with Filters in Power BI
Rating 4.4 of 115 users Rating 4.4 of 115 users (115)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course PL-300: Leveraging Power BI with Ribbon, Line, Column, & Pie Charts
Rating 4.6 of 102 users Rating 4.6 of 102 users (102)
Course PL-300: Working with Filters in Power BI
Rating 4.4 of 115 users Rating 4.4 of 115 users (115)
Course PL-300: Understanding Data Visualization
Rating 4.5 of 407 users Rating 4.5 of 407 users (407)