Check relationships - Power BI Tutorial

Contents

• Introduction Introduction

  • Build powerful data models with DAX

    45s
  • What you will need

    2m 56s
• 1. Set Up the Data Model 1. Set Up the Data Model

  • Data modeling: The basics

    3m 33s
  • Get data for your model

    1m 45s
  • Check relationships

    3m 15s
• 2. DAX Aggregate Functions 2. DAX Aggregate Functions

  • Create a measure with SUM

    2m 47s
  • Understanding DAX syntax

    1m 51s
  • Display the measure in a matrix

    1m 15s
  • Format a measure

    1m 33s
  • Create measures with COUNT and COUNTROWS

    3m 23s
  • Delete or edit a measure

    4m 29s
  • Check your data with COUNTBLANK

    1m 36s
  • Create a measure with DISTINCTCOUNT

    2m 28s
• 3. Measures and Calculated Columns 3. Measures and Calculated Columns

  • Add a calculated column

    4m 38s
  • Understand explicit vs. implicit measures

    2m 27s
  • Create a measure with operators

    3m 31s
  • Create a measure with DIVIDE

    4m 29s
  • Iterators and row context: SUMX

    4m 12s
  • Basic DAX date and time functions

    4m 41s
• 4. DAX Logical and Filter Functions 4. DAX Logical and Filter Functions

  • Use FIND

    2m 7s
  • Use IF

    2m 3s
  • Use OR to handle case sensitivity

    3m 17s
  • Use CALCULATE to create a simple filter

    3m 14s
  • Use SWITCH

    3m 4s
• 5. Using DAX Time Intelligence Functions 5. Using DAX Time Intelligence Functions

  • DAX time intelligence functions

    3m 32s
  • Summarize year-to-date with DATESYTD

    3m 25s
  • Visualize cumulative YTD data

    2m 26s
  • Compare totals with SAMEPERIODLASTYEAR

    2m 42s
• Conclusion Conclusion

  • Next steps

    59s