Another advantage of Power BI is how easily time intelligence can be added to your data model. Within data analysis expressions (DAX), you have a comprehensive list of built-in time intelligence functions to make this very easy. In this section, you are going to use these built-in functions to create the following measures:
- Year to Date Sales
- Year to Date Sales (Fiscal Calendar)
- Prior Year Sales