Time Intelligence in Power BI

 

Session Outline: Time Intelligence in Power BI (20 min)

📌 1. What is Time Intelligence? (2 min)

• Time intelligence functions help in analyzing data over time-based periods (Year, Quarter, Month, Week).
• Commonly used in financial, sales, and operational reporting.

📌 2. Common Time Intelligence Functions (10 min)

• TOTALYTD – Calculates Year-to-Date values

  DAX
  Sales YTD = TOTALYTD(SUM(Sales[Amount]), 'Date'[Date])
  

• TOTALQTD – Calculates Quarter-to-Date values

  DAX
  Sales QTD = TOTALQTD(SUM(Sales[Amount]), 'Date'[Date])
  

• TOTALMTD – Calculates Month-to-Date values

  DAX
  Sales MTD = TOTALMTD(SUM(Sales[Amount]), 'Date'[Date])
  

• SAMEPERIODLASTYEAR – Compares the same period in the previous year

  DAX
  Sales LY = CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date]))
  

• DATEADD – Shifts dates by a specified interval

  DAX
  Sales Last Month = CALCULATE(SUM(Sales[Amount]), DATEADD('Date'[Date], -1, MONTH))
  

📌 3. Demo – Implementing Time Intelligence in Power BI (5 min)

• Create a line chart comparing Sales YTD vs. Sales LY.
• Use slicer filters (Year, Month) to see changes dynamically.

📌 4. Best Practices & Summary (3 min)

• Ensure you have a proper Date Table in the model.
• Always use the Date column from the Date Table in DAX functions.
• Time intelligence functions are essential for trend analysis and comparisons.