-
Book Overview & Buying
-
Table Of Contents
Financial Modeling and Reporting with Microsoft Power BI
By :
In order to track how financial metrics are changing, we need to track our data over time, by using Power BI's time intelligence functions.
We will focus our attention on two ideas: period-to-date and period-on-period change. The ideas behind these can be extended to more use cases. The examples here will use revenue, but again, you can substitute any measure into these, such as accounts receivable or inventory.
Before we start, we use the words "easy" and "hard" deliberately. Power BI has a full set of time intelligence features that work with our standard calendars. If your organization uses standard calendars, Power BI's functions make time intelligence very easy. That can extend to offset fiscal years, such as starting the fiscal year in July, instead of January. We must make some adjustments to the calendar table, but it's still straightforward, fitting into the "easy" category.
The "hard" way...