-
Book Overview & Buying
-
Table Of Contents
Financial Modeling and Reporting with Microsoft Power BI
By :
In Chapter 3, we started to apply DAX to populate visualizations for the Trial Balance and Income Statement reports. In this chapter, we're going to build on that work by introducing some of the most common DAX measures that finance professionals use. The intention is to maintain the momentum of the previous chapter by going deeper into the DAX language to develop your skills through the applied use of DAX.
We started gently in Chapter 3, with a few step-by-step examples. As we're working on the basis that readers of this book already have some DAX knowledge, we're going to pick up the pace and focus on how to write and use DAX without step-by-step guides. By now, you know how to add measures and write DAX, so you'll be able to apply our examples.
We'll start by introducing the CALCULATE function. After that, we'll cover percentages and time intelligence, and end with DAX functions for foreign exchange. We also recommend...