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.