Microsoft Certified: Fabric Analytics Engineer AssociateImplement and manage semantic models (30-35%)Easy
A data engineer is designing a semantic model in Microsoft Fabric. The model needs to track customer interactions over time, and a key requirement is to analyze data for specific time periods, including year-to-date, quarter-to-date, and month-to-date. The underlying data source does not contain these specific time intelligence calculations. Which DAX function category is designed to create these types of calculations efficiently?
- AFilter functions
- BTime intelligence functions
- CText functions
- DLogical functions
Show answer & explanationAnswer & explanation
Correct answer: B. Time intelligence functions
DAX time intelligence functions are specifically designed to enable calculations that involve time periods, such as year-to-date, quarter-to-date, and month-to-date, by working with a properly configured date table.
Why the other options are wrong
- A. Filter functions modify the filter context but are not specifically designed for common time-based aggregations.
- C. Text functions manipulate string values and are irrelevant for date-based calculations.
- D. Logical functions evaluate conditions and return TRUE/FALSE, not for time-based aggregations.
DAX Time Intelligence
DAX Time Intelligence functions facilitate calculations across various time periods (e.g., YTD, QTD, MTD, moving averages) within a semantic model, requiring a marked date table for proper functionality.
- Requires a dedicated and marked Date table.
- Simplifies complex date-based comparisons and aggregations.
- Functions like TOTALYTD, DATESBETWEEN, SAMEPERIODLASTYEAR.
Memory trick: DAX Functions: Do You Know Your Time, Text, and Logic?