Scribd Logo
Upload

Welcome to Scribd!

  • 195 views

    Power Bi Dax

    Uploaded by

    Anubha Verma
    Powerbi dax

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Power Bi Dax

    Uploaded by

    Anubha Verma
    195 views1 page
    Powerbi dax

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Powerbi dax

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    195 views1 page

    Power Bi Dax

    Uploaded by

    Anubha Verma
    Powerbi dax

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    Course Length --------------------------------------------------------- 1 Day

    Course Format --------------------------------------------- Instructor-Led

    www.CompuTrain.com

    Microsoft® Power BI® - DAX


    DAX Functions – Creating Measures and KPIs

    Course Description
    Course Overview: DAX Functions are an essential part of getting the most out of Power BI. They can make asking complicated
    questions about your data easy. This course covers more than 50 DAX functions that just about every type of Power BI user will use
    at one time or another.

    Target Student: This course is for students who are part of the data modeling team for their organization. This course is for active
    learners who need to write the calculations to answer their organization’s questions.

    Prerequisites: To ensure your success, we recommend you first take the following CompuTrain courses or have equivalent
    knowledge: Microsoft® Power BI® - Smart Start, or Microsoft® Power BI® - Data Modeling.

    Course Objectives
    Upon successful completion of this course, students will be able to:
    • Use DAX Functions
    • Create Measures
    • Create KPIs
    • Understand Iterator Functions
    • Use Time Intelligence Functions
    • Use Inactive Relationships in Measures
    • Use Data from Related Tables

    Course Content
    Lesson 1: Introduction to DAX Lesson 4: Understanding Filter Propagation
    • What is DAX? • Understanding Filter Context
    • Calculated Columns vs Measures • Altering the Query Context
    • Understanding the Syntax of DAX • Creating Advanced Filters
    • Understanding Implicit vs Explicit Measures
    Lesson 5: Basic Iterator Functions
    Lesson 2: Understanding Date Tables • Understanding Row Context
    • Creating a Date Table • When to use X-Functions vs Aggregators
    • Creating a Date Hierarchy • Using Iterator Functions
    • Using Single Date Functions
    Lesson 6: Incorporating Time Intelligence
    Lesson 3: Creating Measures with DAX • Using DAX Date and Time Functions
    • Working with Text Functions • Shifting the Date Context
    • Using Statistical Functions
    • Creating Logical Functions Lesson 7: Relationship Building Calculations
    • Tips for Creating Calculations in Power Pivot • Getting Data from Related Tables
    • Creating KPIs • Using Inactive Relationships in Measures

    CompuTrain Business Solutions, Ltd.  6800 W. Loop South, Suite 400  Bellaire, TX 77401  (713) 349-9186
    Page 1 of 1

    You might also like