O'Reilly logo

Microsoft Tabular Modeling Cookbook by Paul te Braak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Performing currency calculations

Currency calculations are a unique type of calculation, because the value that is returned to the user needs to be dynamically determined within the model, based on their input (choice of currency). This relies on two dynamic types of data, which can change within the model and therefore may impact the calculation. Firstly, the rate used can be changed (that is, a change to the rate of existing data) or secondly, new currencies can be added or removed to the currency data that requires a new conversion to be created. Unlike the previous calculations that we have seen in this book, the calculation must dynamically determine the rate that is to be applied in conversions based on the available data in the model. Because ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required