Basic DAX date and time functions - Power BI Tutorial

Contents

• Introduction Introduction

  • Build powerful data models with DAX

    45s
  • What you'll need

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

  • Data modeling: The basics

    3m 33s
  • (Locked)
    Get data for your model

    1m 45s
  • (Locked)
    Check relationships

    3m 15s
  • (Locked)
    Save your data model

    45s
• 2. DAX Aggregate Functions 2. DAX Aggregate Functions

  • (Locked)
    Create a measure with SUM

    2m 47s
  • (Locked)
    Understanding DAX syntax

    1m 51s
  • (Locked)
    Display the measure in a matrix

    1m 15s
  • (Locked)
    Format a measure

    1m 33s
  • (Locked)
    Create measures with COUNT functions

    3m 23s
  • (Locked)
    Delete or edit a measure

    4m 29s
  • (Locked)
    Check your data with COUNTBLANK

    1m 36s
  • (Locked)
    Create a measure with DISTINCTCOUNT

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

  • (Locked)
    Add a calculated column

    4m 38s
  • (Locked)
    Understand explicit and implicit measures

    2m 27s
  • (Locked)
    Create a measure with operators

    3m 31s
  • (Locked)
    Create a measure with DIVIDE

    4m 29s
  • (Locked)
    Iterators and row context: SUMX

    4m 12s
  • (Locked)
    Basic DAX date and time functions

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

  • (Locked)
    Use FIND

    2m 7s
  • (Locked)
    Use IF

    2m 3s
  • (Locked)
    Use OR to handle case sensitivity

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

    3m 14s
  • (Locked)
    Use SWITCH

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

  • (Locked)
    DAX time-intelligence functions

    3m 32s
  • (Locked)
    Summarize year-to-date information with DATESYTD

    3m 25s
  • (Locked)
    Visualize cumulative YTD data

    2m 26s
  • (Locked)
    Compare totals with SAMEPERIODLASTYEAR

    2m 42s
• Conclusion Conclusion

  • (Locked)
    Next steps

    59s