DAX calcula intervalos de datas para modelagem em dados

It looks like you’ve shared a comprehensive explanation on how to create custom date ranges using DAX functions in Power BI or Fabric. Here’s a recap and some additional insights to help deepen your understanding of DAX date functions.

Summary of Key Points

1. Date Range Functions:

   • DATESINPERIOD():
     • Takes a start date and a number of intervals (days, months, quarters, years).
     • Useful for creating a range based on a specified length from a start date.
   • DATESBETWEEN():
     • Requires explicit start and end dates.
     • All dates between and including these dates are included in the result.
   • DATEADD():
     • Uses the current filter context to determine the start date and adds/subtracts a specified interval.

2. Defining Start Dates:

   • You can define start dates as strings (e.g., "2025-05-05") or as date values using the DATE() function, which is better for date operations.

3. Example Queries:

   • For getting a date range of 25 days using DATESINPERIOD():
     dax
     DATESINPERIOD(‘Date'[Date], StartDate, 25, DAY)

   • For a range of two months:
     dax
     DATESINPERIOD(‘Date'[Date], StartDate, 2, MONTH)

   • Using DATESBETWEEN():
     dax
     DATESBETWEEN(‘Date'[Date], StartDate, EndDate)
4. Measure Example:
   • You defined measures for a rolling total using both DATESINPERIOD() and DATESBETWEEN(), highlighting that both can compute rolling totals but have different conditions for start and end dates.

Practical Application in Power BI

When using these functions to create measures and perform time intelligence calculations, consider the following:

• Context Awareness: DAX is context-sensitive. Ensure your measures account for both row context and filter context effectively.
• Performance: Using functions that effectively handle dates can enhance performance and maintainability. Prefer measures that minimize complex calculations during runtime.
• Testing Queries: Use tools like DAX Studio to test and optimize your DAX queries. It can provide insights into performance and debug potential issues.

Next Steps

1. Expansion on Complex Scenarios: Try combining these date functions with additional filters or calculations to solve more complex business questions.
2. Integration with Other Data: Use time intelligence in conjunction with sales, inventory, or other metrics to derive insights.
3. Learning Resources: Continue exploring resources on DAX and time intelligence to build proficiency, especially with real-world data models.

Feel free to ask if you have specific scenarios or further questions about DAX or Power BI!