From the course: Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Time-intelligence functions

Time-intelligence functions - Power BI Tutorial

From the course: Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX

Start my 1-month free trial Buy for my team

Time-intelligence functions

“

- [Instructors] Time intelligence functions allow us to manipulate data using time periods. This includes days, months, quarters, and years. An example of this is financial analysis, which includes quarter to date, month to date, and year to date comparisons and analysis. We usually see financial data being represented on a quarterly basis or yearly basis in financial statements, reports, or dashboards. Time intelligence functions allow us the opportunity to use predefined calculations for time-based analysis. Let's look at two examples. So we're using the time intelligence startup Power BI file, and we've loaded a matrix visual showing sales by year and month. If we would like to compare sales of one month to the previous month, we can use the previous month function. This function returns a single column of dates from the previous month based on the first date that we use as our input. So this is useful for comparing…

Contents