SELF-GUIDED BA PRACTICE Packages available · Access after confirmed paymentSee packages ↗

Business analysis glossary

Time Intelligence

What it is

Time intelligence refers to calculations that compare values across time periods, such as year to date, month on month change, same period last year or a rolling twelve month total. In Power BI these are DAX functions that need a proper date table to work correctly.

Why it matters

Business users judge performance by comparison: is this month better than last month or last year? Time intelligence answers that. Indian financial years run from April to March, so analysts must make sure the date table and year to date measures use the right year start.

Example

The analyst builds a measure for sales year to date that resets every first of April, and another for the same period last year. The finance head can now see that sales are twelve percent up on last year so far, even though the calendar year comparison looked flat.

CHECK BEFORE CONTINUING

Keep your work safe