Skip to Content
0
Mar 09 at 08:57 PM

Calculate a difference column showing difference from Input Measure Control

58 Views

Hi,

In our company, we are in the progress of developing a planning story & model for next year

I have added Actual 2021, 2022 and 2023, Budget 2023 and Planning 2024 to the table as columns - see screenshot below. We are using the new model for the story. In the planning story, the numbers are created using currency conversion measures with input measure control added. So for all numbers in the table, we can switch between 4 different reporting currencies we have + local currency for the specific companies.

When I have these numbers in the table, how can I create a dynamic difference column where the end-users can compare the different periods specified in the table below against Planning 2024? Is this possible, with input measure control used in the table?

image.png

Model measures:

Value Local Currency

Conversion Measures:

Value_Currency1

Value_Currency2

Value_Currency3

Value_Currency4

Value_LocalCurrency

Dimensions used:

G/L accounts

Cost Center list

Date

Version

Help is much appreciated :-)

Attachments

image.png (40.3 kB)