Model: Group Reporting - Specifications for Fact Table: STRUCTURE BASED ANALYSIS MEASURES

On this page you will find the specifications regarding the Model: Group Reporting and Fact Table: STRUCTURE BASED ANALYSIS MEASURES.

This table contains all the measures that are based on the IFS Cloud fact FACT_CONSOL_BALANCE_STRUCTBASED.

Attributes

Attribute

Description (where applicable)

Measures (table to be generated as far as possible)

Aggregation of measures is based on SUM if not explicitly noted.

This section describes the basic measures in the cube. These are either measures defined in the core Information Source, in the model itself or in the ETL process. The columns have the following meaning:

Core Measure: A measure that has its origin in a core Information Source
Calculated Y/N: A measure specifically defined for the model, e.g. percentages etc. These measures do not derive from the Information Source.
Contains Time Intelligence Y/N: Some measures do also have additional time intelligence measures like Year To Date (YTD) Se separate section.
Definition/Note: Specifies if there is a specific logic behind a measure. More information might also be found in documentation for Information Sources.
Aggregation Type: Specifies the aggregation type of a measure.
Hidden Y/N: Specifies if a measure is hidden and there by not visible to the end user when browsing the model.
Tabular Expression: The DAX expression in the measure definition.

Measure	Calculated Y/N	Contains Time Intelligence Y/N	Definition/Note (where applicable)	Aggregation Type	Hidden Y/N	Tabular Expression
ACT	Y	N	Calculates period balance for the selected balance set. This measure can present period balances by accounting period and total for multiple periods (for example annual totals). This measure presents values in the NODE currency.	SUM	N	VAR Result = CALCULATE(SUM('FACT STRUCTURE BASED ANALYSIS'[STR_BALANCE]), FILTER('BALANCE SET', 'BALANCE SET'[Measure Name]="ACT")) RETURN Result // Calculates period balance for the selected balance set. // This measure can present 'period balances' by accounting period and total for multiple periods (for example annual totals). // This measure presents values in the NODE currency. // Prerequisite: Source columns containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT GC	Y	N	Calculates period balance for the selected balance set. This measure can present period balances by accounting period and total for multiple periods (for example annual totals). This measure presents values in the GROUP currency.	SUM	N	VAR Result = CALCULATE(SUM('FACT STRUCTURE BASED ANALYSIS'[STR_BALANCE_GC]), FILTER('BALANCE SET', 'BALANCE SET'[Measure Name]="ACT")) RETURN Result // Calculates period balance for the selected balance set. // This measure can present 'period balances' by accounting period and total for multiple periods (for example annual totals). // This measure presents values in the GROUP currency. // Prerequisite: Source columns containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT OB	Y	Y	OB values is the same as YTD for the previous accounting period. This measures is needed for the calculation of the (YTD Based) X-rate measures. For Accounting period = 0 the rate value will be blank since period -1 does not exist. The logic does not look for the rate value from the last period in previous year. For Accounting period = 1 the rate value will be blank for Account Type = Income Statement, but have the value from period 0 when Account Type = Balance Sheet.	SUM	Y	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [ACT YTD], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod -1 ) RETURN result // OB values is the same as YTD for the previous accounting period. This measures is needed for the calculation of the (YTD Based) X-rate measures. // For Accounting period = 0 the rate value will be blank since period -1 does not exist. The logic does not look for the rate value from the last period in previous year. // For Accounting period = 1 the rate value will be blank for Account Type = 'Income Statement', but have the value from period 0 when Account Type = 'Balance Sheet'.
ACT PY GC	Y	Y	Calculates period balance for the corresponding accounting period last year. This measure can present period balances by accounting period or filtered on one single period. While for example annual totals will show blank values. This measure presents values in the GROUP currency. Prerequisite: Exact same set of accounting periods in both current and previous year.	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [ACT GC], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN //IF([HasOneAccountPeriod] = FALSE(), BLANK(), result) result // Calculates period balance for the corresponding accounting period last year. // This measure can present 'period balances' by accounting period or filtered on one single period. While for example annual totals will show blank values. // This measure presents values in the GROUP currency. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT PY XR1 (Period Based)	Y	Y	Recalculates period balance, with method (Period Based), from node currency to one selected TO currency for the corresponding accounting period last year. This measure presents period balances by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. Prerequisite: Exact same set of accounting periods in both current and previous year.	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [ACT XR1 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN result // Recalculates period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT PY XR1 (YTD Based)	Y	Y	Recalculates period balance, with method (YTD Based), from node currency to one selected TO currency for the corresponding accounting period last year. This measure presents period balances by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. Prerequisite: Exact same set of accounting periods in both current and previous year.	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) -1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [ACT XR1 (YTD Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod) RETURN result // Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT PY XR2 (Period Based)	Y	Y	Recalculates period balance, with method (Period Based), from node currency to one selected TO currency for the corresponding accounting period last year. This measure presents period balances by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. Prerequisite: Exact same set of accounting periods in both current and previous year.	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [ACT XR2 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN result // Recalculates period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods + for all accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT PY XR2 (YTD Based)	Y	Y	Recalculates period balance, with method (YTD Based), from node currency to one selected TO currency for the corresponding accounting period last year. This measure presents period balances by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. Prerequisite: Exact same set of accounting periods in both current and previous year.	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) -1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [ACT XR2 (YTD Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod) RETURN result // Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods + for all accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT PY YTD GC	Y	Y	Calculates period balance for the corresponding accounting period last year. This measure can present period balances by accounting period or filtered on one single period. While for example annual totals will show blank values. This measure presents values in the GROUP currency. Prerequisite: Exact same set of accounting periods in both current and previous year.	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [ACT YTD GC], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN IF([HasOneAccountPeriod] = FALSE(), BLANK(), result) // Calculates YTD balance for the corresponding accounting period last year. // This measure can present 'YTD balances' by accounting period or filtered on one single period. While for example annual totals will show blank values. // This measure presents values in the GROUP currency. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT PY YTD XR1 (Period Based)	Y	Y	Recalculates YTD balance, with method (Period Based), from node currency to one selected TO currency for the corresponding accounting period last year. This measure presents YTD balances by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. Prerequisite: Exact same set of accounting periods in both current and previous year.	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [ACT YTD XR1 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN result // Recalculates YTD balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT PY YTD XR1 (YTD Based)	Y	Y	Recalculates YTD balance, with method (YTD Based), from node currency to one selected TO currency for the corresponding accounting period last year. This measure presents YTD balances by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. Prerequisite: Exact same set of accounting periods in both current and previous year.	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) -1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [ACT YTD XR1 (YTD Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod) RETURN result // Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT PY YTD XR2 (Period Based)	Y	Y	Recalculates YTD balance, with method (Period Based), from node currency to one selected TO currency for the corresponding accounting period last year. This measure presents YTD balances by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. Prerequisite: Exact same set of accounting periods in both current and previous year.	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [ACT YTD XR2 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN result // Recalculates period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods + for all accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT PY YTD XR2 (YTD Based)	Y	Y	Recalculates YTD balance, with method (YTD Based), from node currency to one selected TO currency for the corresponding accounting period last year. This measure presents YTD balances by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. Prerequisite: Exact same set of accounting periods in both current and previous year.	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) -1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [ACT YTD XR2 (YTD Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod) RETURN result // Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods + for all accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT XR1 (Period Based)	Y	Y	Recalculates period balance from node currency to one selected TO currency for the selected balance set. This measure presents period balances by accounting period or total for a selection of multiple periods. Prerequisite: Rate table containing rates for all displayed accounting periods.	SUM	N	VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT STRUCTURE BASED ANALYSIS' ,'ACCOUNTING PERIOD'[Accounting Year Period],'X-RATE 1 FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([ACT]) ,"@XRates" ,CALCULATE([Conversion Rate XR1]) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // Recalculates period balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'period balances' by accounting period or total for a selection of multiple periods. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT XR1 (YTD Based)	Y	Y	Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the selected balance set. This measure presents period balances by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. Prerequisite: Rate table containing rates for all displayed accounting periods. Prerequisite: Source measure [ACT] contains period balances, [ACT YTD] contains YTD balances and [ACT OB] contains YTD balance for the previous period.	SUM	N	VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) RETURN IF( CurrPeriod = 0, SUMX (VALUES ( 'X-RATE 1 FROM CURRENCY'[From Currency Code] ), ([ACT][Conversion rate XR1]) ), SUMX (VALUES ( 'X-RATE 1 FROM CURRENCY'[From Currency Code] ), ([ACT YTD][Conversion rate XR1]) - [ACT OB]*[Conversion rate PP XR1]) ) // Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure [ACT] contains period balances, [ACT YTD] contains YTD balances and [ACT OB] contains YTD balance for the previous period. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT XR2 (Period Based)	Y	Y	Recalculates period balance, with method (Period Based), from node currency to one selected TO currency for the selected balance set. This measure presents period balances by accounting period or total for a selection of multiple periods. Prerequisite: Rate table containing rates for all displayed accounting periods.	SUM	N	VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT STRUCTURE BASED ANALYSIS' ,'ACCOUNTING PERIOD'[Accounting Year Period],'X-RATE 2 FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([ACT]) ,"@XRates" ,CALCULATE([Conversion Rate XR2]) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // Recalculates period balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'period balances' by accounting period or total for a selection of multiple periods. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT XR2 (YTD Based)	Y	Y	Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the selected balance set. This measure presents period balances by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. Prerequisite: Rate table containing rates for all displayed accounting periods. Prerequisite: Source measure [ACT] contains period balances, [ACT YTD] contains YTD balances and [ACT OB] contains YTD balance for the previous period.	SUM	N	VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) RETURN IF( CurrPeriod = 0, SUMX (VALUES ( 'X-RATE 2 FROM CURRENCY'[From Currency Code] ), ([ACT][Conversion rate XR2]) ), SUMX (VALUES ( 'X-RATE 2 FROM CURRENCY'[From Currency Code] ), ([ACT YTD][Conversion rate XR2]) - [ACT OB]*[Conversion rate PP XR2]) ) // Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'period balances' by accounting period. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure [ACT] contains period balances, [ACT YTD] contains YTD balances and [ACT OB] contains YTD balance for the previous period. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT YTD GC	Y	Y	Calculates YTD balance for the selected balance set. This measure can present YTD balances by accounting period and total for multiple periods (for example annual totals). This measure presents values in the GROUP currency. Prerequisite: Exact same set of accounting periods in both current and previous year.	SUM	N	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR Result = CALCULATE ( SUM('FACT STRUCTURE BASED ANALYSIS'[STR_BALANCE_GC]), FILTER('BALANCE SET', 'BALANCE SET'[Measure Name]="ACT"), FILTER ( ALL ( 'ACCOUNTING PERIOD' ), 'ACCOUNTING PERIOD'[Accounting Period No] <= CurrPeriod && 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear) ) VAR TotalAllPeriods = CALCULATE(SUM('FACT STRUCTURE BASED ANALYSIS'[STR_BALANCE_GC]), FILTER('BALANCE SET', 'BALANCE SET'[Measure Name]="ACT")) RETURN IF([HasOneAccountPeriod] = FALSE(), TotalAllPeriods, result) // Calculates YTD balance for the selected balance set. // This measure can present 'YTD balances' by accounting period and total for multiple periods (for example annual totals). // This measure presents values in the GROUP currency. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source column containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT YTD XR1 (Period Based)	Y	Y	Recalculates YTD balance, with method (Period Based), from node currency to one selected TO currency for the selected balance set. This measure presents YTD balances by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. Prerequisite: Rate table containing rates for all displayed accounting periods.	SUM	N	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [ACT XR1 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear, 'ACCOUNTING PERIOD'[Accounting Period No] <= CurrPeriod ) RETURN result // Recalculates YTD balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT YTD XR1 (YTD Based)	Y	Y	Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the selected balance set. This measure presents YTD balances by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. Prerequisite: Rate table containing rates for all displayed accounting periods.	SUM	N	SUMX( VALUES( 'X-RATE 1 FROM CURRENCY'[From Currency Code] ), CALCULATE( [ACT YTD] * [Conversion Rate XR1] )) // Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT YTD XR2 (Period Based)	Y	Y	Recalculates YTD balance, with method (Period Based), from node currency to one selected TO currency for the selected balance set. This measure presents YTD balances by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. Prerequisite: Rate table containing rates for all displayed accounting periods.	SUM	N	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [ACT XR2 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear, 'ACCOUNTING PERIOD'[Accounting Period No] <= CurrPeriod ) RETURN result // Recalculates YTD balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
ACT YTD XR2 (YTD Based)	Y	Y	Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the selected balance set. This measure presents YTD balances by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. Prerequisite: Rate table containing rates for all displayed accounting periods.	SUM	N	SUMX( VALUES( 'X-RATE 2 FROM CURRENCY'[From Currency Code] ), CALCULATE( [ACT YTD] * [Conversion Rate XR2] )) // Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD	Y	N	see ACT	SUM	N	VAR Result = CALCULATE(SUM('FACT STRUCTURE BASED ANALYSIS'[STR_BALANCE]), FILTER('BALANCE SET', 'BALANCE SET'[Measure Name]="BUD")) RETURN Result // Calculates period balance for the selected balance set. // This measure can present 'period balances' by accounting period and total for multiple periods (for example annual totals). // This measure presents values in the NODE currency // Prerequisite: Source columns containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD GC	Y	N	see ACT GC	SUM	N	VAR Result = CALCULATE(SUM('FACT STRUCTURE BASED ANALYSIS'[STR_BALANCE_GC]), FILTER('BALANCE SET', 'BALANCE SET'[Measure Name]="BUD")) RETURN Result // Calculates period balance for the selected balance set. // This measure can present 'period balances' by accounting period and total for multiple periods (for example annual totals). // This measure presents values in the GROUP currency. // Prerequisite: Source columns containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD OB	Y	Y	see ACT OB	SUM	Y	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [BUD YTD], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod -1 ) RETURN result // OB values is the same as YTD for the previous accounting period. This measures is needed for the calculation of the (YTD Based) X-rate measures. // For Accounting period = 0 the rate value will be blank since period -1 does not exist. The logic does not look for the rate value from the last period in previous year. // For Accounting period = 1 the rate value will be blank for Account Type = 'Income Statement', but have the value from period 0 when Account Type = 'Balance Sheet'.
BUD PY GC	Y	Y	see ACT PY GC	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [BUD GC], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN IF([HasOneAccountPeriod] = FALSE(), BLANK(), result) // Calculates period balance for the corresponding accounting period last year. // This measure can present 'period balances' by accounting period or filtered on one single period. While for example annual totals will show blank values. // This measure presents values in the GROUP currency. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD PY XR1 (Period Based)	Y	Y	see ACT PY XR1 (Period Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [BUD XR1 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN result // Recalculates period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD PY XR1 (YTD Based)	Y	Y	see ACT PY XR1 (YTD Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) -1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [BUD XR1 (YTD Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod) RETURN result // Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD PY XR2 (Period Based)	Y	Y	see ACT PY XR2 (Period Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [BUD XR2 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN result // Recalculates period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods + for all accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD PY XR2 (YTD Based)	Y	Y	see ACT PY XR2 (YTD Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) -1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [BUD XR2 (YTD Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod) RETURN result // Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods + for all accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD PY YTD GC	Y	Y	see ACT PY YTD GC	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [BUD YTD GC], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN IF([HasOneAccountPeriod] = FALSE(), BLANK(), result) // Calculates YTD balance for the corresponding accounting period last year. // This measure can present 'YTD balances' by accounting period or filtered on one single period. While for example annual totals will show blank values. // This measure presents values in the GROUP currency. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD PY YTD XR1 (Period Based)	Y	Y	see ACT PY YTD XR1 (Period Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [BUD YTD XR1 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN result // Recalculates YTD balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD PY YTD XR1 (YTD Based)	Y	Y	see ACT PY YTD XR1 (YTD Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) -1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [BUD YTD XR1 (YTD Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod) RETURN result // Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD PY YTD XR2 (Period Based)	Y	Y	see ACT PY YTD XR2 (Period Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [BUD YTD XR2 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN result // Recalculates period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods + for all accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD PY YTD XR2 (YTD Based)	Y	Y	see ACT PY YTD XR2 (YTD Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) -1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [BUD YTD XR2 (YTD Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod) RETURN result // Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods + for all accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD XR1 (Period Based)	Y	Y	see ACT XR1 (Period Based)	SUM	N	VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT STRUCTURE BASED ANALYSIS' ,'ACCOUNTING PERIOD'[Accounting Year Period],'X-RATE 1 FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([BUD]) ,"@XRates" ,CALCULATE([Conversion Rate XR1]) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // Recalculates period balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'period balances' by accounting period or total for a selection of multiple periods. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD XR1 (YTD Based)	Y	Y	see ACT XR1 (YTD Based)	SUM	N	VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) RETURN IF( CurrPeriod = 0, SUMX (VALUES ( 'X-RATE 1 FROM CURRENCY'[From Currency Code] ), ([BUD][Conversion rate XR1]) ), SUMX (VALUES ( 'X-RATE 1 FROM CURRENCY'[From Currency Code] ), ([BUD YTD][Conversion rate XR1]) - [BUD OB]*[Conversion rate PP XR1]) ) // Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure [BUD] contains period balances, [BUD YTD] contains YTD balances and [BUD OB] contains YTD balance for the previous period. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD XR2 (Period Based)	Y	Y	see ACT XR2 (Period Based)	SUM	N	VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT STRUCTURE BASED ANALYSIS' ,'ACCOUNTING PERIOD'[Accounting Year Period],'X-RATE 2 FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([BUD]) ,"@XRates" ,CALCULATE([Conversion Rate XR2]) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // Recalculates period balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'period balances' by accounting period or total for a selection of multiple periods. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD XR2 (YTD Based)	Y	Y	see ACT XR2 (YTD Based)	SUM	N	VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) RETURN IF( CurrPeriod = 0, SUMX (VALUES ( 'X-RATE 2 FROM CURRENCY'[From Currency Code] ), ([BUD][Conversion rate XR2]) ), SUMX (VALUES ( 'X-RATE 2 FROM CURRENCY'[From Currency Code] ), ([BUD YTD][Conversion rate XR2]) - [BUD OB]*[Conversion rate PP XR2]) ) // Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'period balances' by accounting period. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure [BUD] contains period balances, [BUD YTD] contains YTD balances and [BUD OB] contains YTD balance for the previous period. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD YTD GC	Y	Y	see ACT YTD GC	SUM	N	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR Result = CALCULATE ( SUM('FACT STRUCTURE BASED ANALYSIS'[STR_BALANCE_GC]), FILTER('BALANCE SET', 'BALANCE SET'[Measure Name]="BUD"), FILTER ( ALL ( 'ACCOUNTING PERIOD' ), 'ACCOUNTING PERIOD'[Accounting Period No] <= CurrPeriod && 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear) ) VAR TotalAllPeriods = CALCULATE(SUM('FACT STRUCTURE BASED ANALYSIS'[STR_BALANCE_GC]), FILTER('BALANCE SET', 'BALANCE SET'[Measure Name]="BUD")) RETURN IF([HasOneAccountPeriod] = FALSE(), TotalAllPeriods, result) // Calculates YTD balance for the selected balance set. // This measure can present 'YTD balances' by accounting period and total for multiple periods (for example annual totals). // This measure presents values in the NODE currency. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source column containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD YTD XR1 (Period Based)	Y	Y	see ACT YTD XR1 (Period Based)	SUM	N	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [BUD XR1 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear, 'ACCOUNTING PERIOD'[Accounting Period No] <= CurrPeriod ) RETURN result // Recalculates YTD balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD YTD XR1 (YTD Based)	Y	Y	see ACT YTD XR1 (YTD Based)	SUM	N	SUMX( VALUES( 'X-RATE 1 FROM CURRENCY'[From Currency Code] ), CALCULATE( [BUD YTD] * [Conversion Rate XR1] )) // Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD YTD XR2 (Period Based)	Y	Y	see ACT YTD XR2 (Period Based)	SUM	N	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [BUD XR2 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear, 'ACCOUNTING PERIOD'[Accounting Period No] <= CurrPeriod ) RETURN result // Recalculates YTD balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
BUD YTD XR2 (YTD Based)	Y	Y	see ACT YTD XR2 (YTD Based)	SUM	N	SUMX( VALUES( 'X-RATE 2 FROM CURRENCY'[From Currency Code] ), CALCULATE( [BUD YTD] * [Conversion Rate XR2] )) // Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC	Y	N	see ACT	SUM	N	VAR Result = CALCULATE(SUM('FACT STRUCTURE BASED ANALYSIS'[STR_BALANCE]), FILTER('BALANCE SET', 'BALANCE SET'[Measure Name]="CFC")) RETURN Result // Calculates period balance for the selected balance set. // This measure can present 'period balances' by accounting period and total for multiple periods (for example annual totals). // This measure presents values in the NODE currency. // Prerequisite: Source columns containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC GC	Y	N	see ACT GC	SUM	N	VAR Result = CALCULATE(SUM('FACT STRUCTURE BASED ANALYSIS'[STR_BALANCE_GC]), FILTER('BALANCE SET', 'BALANCE SET'[Measure Name]="CFC")) RETURN Result // Calculates period balance for the selected balance set. // This measure can present 'period balances' by accounting period and total for multiple periods (for example annual totals). // This measure presents values in the GROUP currency. // Prerequisite: Source columns containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC OB	Y	Y	see ACT OB	SUM	Y	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [CFC YTD], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod -1 ) RETURN result // OB values is the same as YTD for the previous accounting period. This measures is needed for the calculation of the (YTD Based) X-rate measures. // For Accounting period = 0 the rate value will be blank since period -1 does not exist. The logic does not look for the rate value from the last period in previous year. // For Accounting period = 1 the rate value will be blank for Account Type = 'Income Statement', but have the value from period 0 when Account Type = 'Balance Sheet'.
CFC PY GC	Y	Y	see ACT PY GC	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [CFC GC], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN IF([HasOneAccountPeriod] = FALSE(), BLANK(), result) // Calculates period balance for the corresponding accounting period last year. // This measure can present 'period balances' by accounting period or filtered on one single period. While for example annual totals will show blank values. // This measure presents values in the GROUP currency. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC PY XR1 (Period Based)	Y	Y	see ACT PY XR1 (Period Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [CFC XR1 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN result // Recalculates period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC PY XR1 (YTD Based)	Y	Y	see ACT PY XR1 (YTD Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) -1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [CFC XR1 (YTD Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod) RETURN result // Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC PY XR2 (Period Based)	Y	Y	see ACT PY XR2 (Period Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [CFC XR2 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN result // Recalculates period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods + for all accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC PY XR2 (YTD Based)	Y	Y	see ACT PY XR2 (YTD Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) -1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [CFC XR2 (YTD Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod) RETURN result // Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods + for all accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC PY YTD GC	Y	Y	see ACT PY YTD GC	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [CFC YTD GC], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN IF([HasOneAccountPeriod] = FALSE(), BLANK(), result) // Calculates YTD balance for the corresponding accounting period last year. // This measure can present 'YTD balances' by accounting period or filtered on one single period. While for example annual totals will show blank values. // This measure presents values in the GROUP currency. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC PY YTD XR1 (Period Based)	Y	Y	see ACT PY YTD XR1 (Period Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [CFC YTD XR1 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN result // Recalculates YTD balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC PY YTD XR1 (YTD Based)	Y	Y	see ACT PY YTD XR1 (YTD Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) -1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [CFC YTD XR1 (YTD Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod) RETURN result // Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC PY YTD XR2 (Period Based)	Y	Y	see ACT PY YTD XR2 (Period Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [CFC YTD XR2 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN result // Recalculates period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods + for all accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC PY YTD XR2 (YTD Based)	Y	Y	see ACT PY YTD XR2 (YTD Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) -1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [CFC YTD XR2 (YTD Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod) RETURN result // Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods + for all accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC XR1 (Period Based)	Y	Y	see ACT XR1 (Period Based)	SUM	N	VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT STRUCTURE BASED ANALYSIS' ,'ACCOUNTING PERIOD'[Accounting Year Period],'X-RATE 1 FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([CFC]) ,"@XRates" ,CALCULATE([Conversion Rate XR1]) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // Recalculates period balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'period balances' by accounting period or total for a selection of multiple periods. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC XR1 (YTD Based)	Y	Y	see ACT XR1 (YTD Based)	SUM	N	VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) RETURN IF( CurrPeriod = 0, SUMX (VALUES ( 'X-RATE 1 FROM CURRENCY'[From Currency Code] ), ([CFC][Conversion rate XR1]) ), SUMX (VALUES ( 'X-RATE 1 FROM CURRENCY'[From Currency Code] ), ([CFC YTD][Conversion rate XR1]) - [CFC OB]*[Conversion rate PP XR1]) ) // Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure [CFC] contains period balances, [CFC YTD] contains YTD balances and [CFC OB] contains YTD balance for the previous period. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC XR2 (Period Based)	Y	Y	see ACT XR2 (Period Based)	SUM	N	VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT STRUCTURE BASED ANALYSIS' ,'ACCOUNTING PERIOD'[Accounting Year Period],'X-RATE 2 FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([CFC]) ,"@XRates" ,CALCULATE([Conversion Rate XR2]) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // Recalculates period balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'period balances' by accounting period or total for a selection of multiple periods. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC XR2 (YTD Based)	Y	Y	see ACT XR2 (YTD Based)	SUM	N	VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) RETURN IF( CurrPeriod = 0, SUMX (VALUES ( 'X-RATE 2 FROM CURRENCY'[From Currency Code] ), ([CFC][Conversion rate XR2]) ), SUMX (VALUES ( 'X-RATE 2 FROM CURRENCY'[From Currency Code] ), ([CFC YTD][Conversion rate XR2]) - [CFC OB]*[Conversion rate PP XR2]) ) // Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'period balances' by accounting period. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure [CFC] contains period balances, [CFC YTD] contains YTD balances and [CFC OB] contains YTD balance for the previous period. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC YTD GC	Y	Y	see ACT YTD GC	SUM	N	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR Result = CALCULATE ( SUM('FACT STRUCTURE BASED ANALYSIS'[STR_BALANCE_GC]), FILTER('BALANCE SET', 'BALANCE SET'[Measure Name]="CFC"), FILTER ( ALL ( 'ACCOUNTING PERIOD' ), 'ACCOUNTING PERIOD'[Accounting Period No] <= CurrPeriod && 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear) ) VAR TotalAllPeriods = CALCULATE(SUM('FACT STRUCTURE BASED ANALYSIS'[STR_BALANCE_GC]), FILTER('BALANCE SET', 'BALANCE SET'[Measure Name]="CFC")) RETURN IF([HasOneAccountPeriod] = FALSE(), TotalAllPeriods, result) // Calculates YTD balance for the selected balance set. // This measure can present 'YTD balances' by accounting period and total for multiple periods (for example annual totals). // This measure presents values in the GROUP currency. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source column containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC YTD XR1 (Period Based)	Y	Y	see ACT YTD XR1 (Period Based)	SUM	N	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [CFC XR1 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear, 'ACCOUNTING PERIOD'[Accounting Period No] <= CurrPeriod ) RETURN result // Recalculates YTD balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC YTD XR1 (YTD Based)	Y	Y	see ACT YTD XR1 (YTD Based)	SUM	N	SUMX( VALUES( 'X-RATE 1 FROM CURRENCY'[From Currency Code] ), CALCULATE( [CFC YTD] * [Conversion Rate XR1] )) // Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC YTD XR2 (Period Based)	Y	Y	see ACT YTD XR2 (Period Based)	SUM	N	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [CFC XR2 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear, 'ACCOUNTING PERIOD'[Accounting Period No] <= CurrPeriod ) RETURN result // Recalculates YTD balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
CFC YTD XR2 (YTD Based)	Y	Y	see ACT YTD XR2 (YTD Based)	SUM	N	SUMX( VALUES( 'X-RATE 2 FROM CURRENCY'[From Currency Code] ), CALCULATE( [CFC YTD] * [Conversion Rate XR2] )) // Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
Conversion Rate PP XR1	Y	Y	Currency rate previous period - for XR1	SUM	N	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [Conversion rate XR1], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod -1 ) RETURN result // Currency Rate for the previous Accounting period. // For Accounting period = 0 the rate value for the previous period will be blank since period -1 does not exist. The logic does not look for the rate value from the last period in previous year. // For Accounting period = 1 the rate value for the previous period for previous period will be the same as period 1. This since period 0 and period 1 has the same rate.
Conversion Rate PP XR2	Y	Y	Currency rate previous period - for XR2	SUM	N	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [Conversion Rate XR2], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod -1 ) RETURN result // Currency Rate for the previous Accounting period. // For Accounting period = 0 the rate value for the previous period will be blank since period -1 does not exist. The logic does not look for the rate value from the last period in previous year. // For Accounting period = 1 the rate value for the previous period for previous period will be the same as period 1. This since period 0 and period 1 has the same rate
Conversion Rate XR1	Y	Y	Currency rate current period - for XR1	SUM	N	VAR AccPeriod_Start_Date = SELECTEDVALUE( 'ACCOUNTING PERIOD'[Acc Period Start Date]) VAR Node_currency = SELECTEDVALUE( 'X-RATE 1 FROM CURRENCY'[From Currency Code]) VAR SelectedToCurrency = SELECTEDVALUE ( 'X-RATE TO CURRENCY'[To Currency Code] ) VAR Rate_Type = SELECTEDVALUE( 'X-RATE 1 RATE TYPE'[Rate Type Code X-Rate 1] ) VAR Conversion_rate = CALCULATE( MAX('X-RATES 1'[CURRENCYRATE]), 'X-RATES 1'[CURRENCY_RATE_DATE_ID] = AccPeriod_Start_Date, 'X-RATES 1'[FROMCURRENCY] = Node_currency, 'X-RATES 1'[TOCURRENCY] = SelectedToCurrency, 'X-RATES 1'[CURRENCY_RATE_TYPE_KEY] = Rate_Type ) RETURN Conversion_rate // Currency Rate for the current Accounting period. // For Accounting period = 0 the rate value will be the same as period 1 since both periods have the same start date.
Conversion Rate XR2	Y	Y	Currency rate current period - for XR2	SUM	N	VAR AccPeriod_Start_Date = SELECTEDVALUE( 'ACCOUNTING PERIOD'[Acc Period Start Date]) VAR Node_currency = SELECTEDVALUE( 'X-RATE 2 FROM CURRENCY'[From Currency Code]) VAR SelectedToCurrency = SELECTEDVALUE ( 'X-RATE TO CURRENCY'[To Currency Code] ) VAR Rate_Type = SELECTEDVALUE( 'X-RATE 2 RATE TYPE'[Rate Type Code X-Rate 2] ) VAR Conversion_rate = CALCULATE( MAX('X-RATES 2'[CURRENCYRATE]), 'X-RATES 2'[CURRENCY_RATE_DATE_ID] = AccPeriod_Start_Date, 'X-RATES 2'[FROMCURRENCY] = Node_currency, 'X-RATES 2'[TOCURRENCY] = SelectedToCurrency, 'X-RATES 2'[CURRENCY_RATE_TYPE_KEY] = Rate_Type ) RETURN Conversion_rate // Currency Rate for the current Accounting period. // For Accounting period = 0 the rate value will be the same as period 1 since both periods have the same start date.
Count Structure Based Analysis	Y	N	Counts the number of rows in the fact table FACT STRUCTURE BASED ANALYSIS	SUM	N	COUNTROWS('FACT STRUCTURE BASED ANALYSIS') //Counts the number of rows in the fact table
NFC	Y	N	see ACT	SUM	N	VAR Result = CALCULATE(SUM('FACT STRUCTURE BASED ANALYSIS'[STR_BALANCE]), FILTER('BALANCE SET', 'BALANCE SET'[Measure Name]="NFC")) RETURN Result // Calculates period balance for the selected balance set. // This measure can present 'period balances' by accounting period and total for multiple periods (for example annual totals). // This measure presents values in the NODE currency. // Prerequisite: Source columns containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC GC	Y	N	see ACT GC	SUM	N	VAR Result = CALCULATE(SUM('FACT STRUCTURE BASED ANALYSIS'[STR_BALANCE_GC]), FILTER('BALANCE SET', 'BALANCE SET'[Measure Name]="NFC")) RETURN Result // Calculates period balance for the selected balance set. // This measure can present 'period balances' by accounting period and total for multiple periods (for example annual totals). // This measure presents values in the GROUP currency. // Prerequisite: Source columns containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC OB	Y	Y	see ACT OB	SUM	Y	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [NFC YTD], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod -1 ) RETURN result // OB values is the same as YTD for the previous accounting period. This measures is needed for the calculation of the (YTD Based) X-rate measures. // For Accounting period = 0 the rate value will be blank since period -1 does not exist. The logic does not look for the rate value from the last period in previous year. // For Accounting period = 1 the rate value will be blank for Account Type = 'Income Statement', but have the value from period 0 when Account Type = 'Balance Sheet'.
NFC PY GC	Y	Y	see ACT PY GC	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [NFC GC], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN IF([HasOneAccountPeriod] = FALSE(), BLANK(), result) // Calculates period balance for the corresponding accounting period last year. // This measure can present 'period balances' by accounting period or filtered on one single period. While for example annual totals will show blank values. // This measure presents values in the GROUP currency. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC PY XR1 (Period Based)	Y	Y	see ACT PY XR1 (Period Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [NFC XR1 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN result // Recalculates period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC PY XR1 (YTD Based)	Y	Y	see ACT PY XR1 (YTD Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) -1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [NFC XR1 (YTD Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod) RETURN result // Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC PY XR2 (Period Based)	Y	Y	see ACT PY XR2 (Period Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [NFC XR2 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN result // Recalculates period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods + for all accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC PY XR2 (YTD Based)	Y	Y	see ACT PY XR2 (YTD Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) -1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [NFC XR2 (YTD Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod) RETURN result // Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods + for all accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC PY YTD GC	Y	Y	see ACT PY YTD GC	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [NFC YTD GC], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN IF([HasOneAccountPeriod] = FALSE(), BLANK(), result) // Calculates YTD balance for the corresponding accounting period last year. // This measure can present 'YTD balances' by accounting period or filtered on one single period. While for example annual totals will show blank values. // This measure presents values in the GROUP currency. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC PY YTD XR1 (Period Based)	Y	Y	see ACT PY YTD XR1 (Period Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [NFC YTD XR1 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN result // Recalculates YTD balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC PY YTD XR1 (YTD Based)	Y	Y	see ACT PY YTD XR1 (YTD Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) -1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [NFC YTD XR1 (YTD Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod) RETURN result // Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC PY YTD XR2 (Period Based)	Y	Y	see ACT PY YTD XR2 (Period Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) - 1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [NFC YTD XR2 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod ) RETURN result // Recalculates period balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods + for all accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC PY YTD XR2 (YTD Based)	Y	Y	see ACT PY YTD XR2 (YTD Based)	SUM	N	VAR PrevYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) -1 VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [NFC YTD XR2 (YTD Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = PrevYear, 'ACCOUNTING PERIOD'[Accounting Period No] = CurrPeriod) RETURN result // Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the corresponding accounting period last year. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods + for all accounting periods in the previous year. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC XR1 (Period Based)	Y	Y	see ACT XR1 (Period Based)	SUM	N	VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT STRUCTURE BASED ANALYSIS' ,'ACCOUNTING PERIOD'[Accounting Year Period],'X-RATE 1 FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([NFC]) ,"@XRates" ,CALCULATE([Conversion Rate XR1]) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // Recalculates period balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'period balances' by accounting period or total for a selection of multiple periods. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC XR1 (YTD Based)	Y	Y	see ACT XR1 (YTD Based)	SUM	N	VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) RETURN IF( CurrPeriod = 0, SUMX (VALUES ( 'X-RATE 1 FROM CURRENCY'[From Currency Code] ), ([NFC][Conversion rate XR1]) ), SUMX (VALUES ( 'X-RATE 1 FROM CURRENCY'[From Currency Code] ), ([NFC YTD][Conversion rate XR1]) - [NFC OB]*[Conversion rate PP XR1]) ) // Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'period balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure [NFC] contains period balances, [NFC YTD] contains YTD balances and [NFC OB] contains YTD balance for the previous period. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC XR2 (Period Based)	Y	Y	see ACT XR2 (Period Based)	SUM	N	VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT STRUCTURE BASED ANALYSIS' ,'ACCOUNTING PERIOD'[Accounting Year Period],'X-RATE 2 FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([NFC]) ,"@XRates" ,CALCULATE([Conversion Rate XR2]) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // Recalculates period balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'period balances' by accounting period or total for a selection of multiple periods. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC XR2 (YTD Based)	Y	Y	see ACT XR2 (YTD Based)	SUM	N	VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) RETURN IF( CurrPeriod = 0, SUMX (VALUES ( 'X-RATE 2 FROM CURRENCY'[From Currency Code] ), ([NFC][Conversion rate XR2]) ), SUMX (VALUES ( 'X-RATE 2 FROM CURRENCY'[From Currency Code] ), ([NFC YTD][Conversion rate XR2]) - [NFC OB]*[Conversion rate PP XR2]) ) // Recalculates, with method (YTD Based), period balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'period balances' by accounting period. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure [NFC] contains period balances, [NFC YTD] contains YTD balances and [NFC OB] contains YTD balance for the previous period. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC YTD GC	Y	Y	see ACT YTD GC	SUM	N	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR Result = CALCULATE ( SUM('FACT STRUCTURE BASED ANALYSIS'[STR_BALANCE_GC]), FILTER('BALANCE SET', 'BALANCE SET'[Measure Name]="NFC"), FILTER ( ALL ( 'ACCOUNTING PERIOD' ), 'ACCOUNTING PERIOD'[Accounting Period No] <= CurrPeriod && 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear) ) VAR TotalAllPeriods = CALCULATE(SUM('FACT STRUCTURE BASED ANALYSIS'[STR_BALANCE_GC]), FILTER('BALANCE SET', 'BALANCE SET'[Measure Name]="NFC")) RETURN IF([HasOneAccountPeriod] = FALSE(), TotalAllPeriods, result) // Calculates YTD balance for the selected balance set. // This measure can present 'YTD balances' by accounting period and total for multiple periods (for example annual totals). // This measure presents values in the GROUP currency. // Prerequisite: Exact same set of accounting periods in both current and previous year. // Prerequisite: Source column containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC YTD XR1 (Period Based)	Y	Y	see ACT YTD XR1 (Period Based)	SUM	N	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [NFC XR1 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear, 'ACCOUNTING PERIOD'[Accounting Period No] <= CurrPeriod ) RETURN result // Recalculates YTD balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC YTD XR1 (YTD Based)	Y	Y	see ACT YTD XR1 (YTD Based)	SUM	N	SUMX( VALUES( 'X-RATE 1 FROM CURRENCY'[From Currency Code] ), CALCULATE( [NFC YTD] * [Conversion Rate XR1] )) // Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC YTD XR2 (Period Based)	Y	Y	see ACT YTD XR2 (Period Based)	SUM	N	VAR CurrYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) VAR CurrPeriod = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) VAR result = CALCULATE( [NFC XR2 (Period Based)], REMOVEFILTERS('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = CurrYear, 'ACCOUNTING PERIOD'[Accounting Period No] <= CurrPeriod ) RETURN result // Recalculates YTD balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing period balances, not YTD balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
NFC YTD XR2 (YTD Based)	Y	Y	see ACT YTD XR2 (YTD Based)	SUM	N	SUMX( VALUES( 'X-RATE 2 FROM CURRENCY'[From Currency Code] ), CALCULATE( [NFC YTD] * [Conversion Rate XR2] )) // Recalculates, with method (YTD Based), YTD balance from node currency to one selected TO currency for the selected balance set. // This measure presents 'YTD balances' by accounting period or need to be filtered to present a single accounting period. While for example annual totals will show blank values. // Prerequisite: Rate table containing rates for all displayed accounting periods. // Prerequisite: Source measure containing YTD balances, not period balances. // Prerequisite: Opening balances stored in accounting period 0 for balance accounts.
Selected ActPY Measure	Y	N	Identify selected version of measure for Actuals Previous Year	N/A	N	CALCULATE(MIN('MEASURE LIST COMPARISON'[Row Index]), ALLEXCEPT('MEASURE LIST COMPARISON','MEASURE LIST COMPARISON'[Dim Comparison Id]), 'MEASURE LIST COMPARISON'[Dim Comparison Id]=1, 'MEASURE LIST COMPARISON'[Dim Currency Type Id]=VALUES('SWITCH CURRENCY TYPE'[Row Index]), 'MEASURE LIST COMPARISON'[Dim Time Perspective Id]=VALUES('SWITCH TIME PERSPECTIVE'[Row Index])) // This measure is preselected to switch between the different benchmark measures for 'Actual Previous Year'
Selected Actual Measure	Y	N	Identify selected version of measure for Actuals	N/A	N	SELECTEDVALUE('MEASURE LIST ACTUAL'[Row Index]) // This measure returns the ID (number) of the selected Actual measures.
Selected Actual XR1 (Period Based) Measure	Y	N	Identify selected version of XR1 (Period Based) measure for Actuals	N/A	N	CALCULATE(MIN('MEASURE LIST ACTUAL'[Row Index]), ALLEXCEPT('MEASURE LIST ACTUAL','MEASURE LIST ACTUAL'[Dim Currency Type Id]), 'MEASURE LIST ACTUAL'[Dim Currency Type Id]=3, 'MEASURE LIST ACTUAL'[Dim Time Perspective Id]=VALUES('SWITCH TIME PERSPECTIVE'[Row Index])) // This measure is preselected to switch between the two different measures for 'Actual XR1 (Period Based)'.
Selected Actual XR1 (YTD Based) Measure	Y	N	Identify selected version of XR1 (YTDBased) measure for Actuals	N/A	N	CALCULATE(MIN('MEASURE LIST ACTUAL'[Row Index]), ALLEXCEPT('MEASURE LIST ACTUAL','MEASURE LIST ACTUAL'[Dim Currency Type Id]), 'MEASURE LIST ACTUAL'[Dim Currency Type Id]=5, 'MEASURE LIST ACTUAL'[Dim Time Perspective Id]=VALUES('SWITCH TIME PERSPECTIVE'[Row Index])) // This measure is preselected to switch between the two different measures for 'Actual XR1 (YTD Based)'.
Selected Actual XR2 (Period Based) Measure	Y	N	Identify selected version of XR2 (Period Based) measure for Actuals	N/A	N	CALCULATE(MIN('MEASURE LIST ACTUAL'[Row Index]), ALLEXCEPT('MEASURE LIST ACTUAL','MEASURE LIST ACTUAL'[Dim Currency Type Id]), 'MEASURE LIST ACTUAL'[Dim Currency Type Id]=4, 'MEASURE LIST ACTUAL'[Dim Time Perspective Id]=VALUES('SWITCH TIME PERSPECTIVE'[Row Index])) // This measure is preselected to switch between the two different measures for 'Actual XR2 (Period Based)'.
Selected Actual XR2 (YTD Based) Measure	Y	N	Identify selected version of XR2 (YTD Based) measure for Actuals	N/A	N	CALCULATE(MIN('MEASURE LIST ACTUAL'[Row Index]), ALLEXCEPT('MEASURE LIST ACTUAL','MEASURE LIST ACTUAL'[Dim Currency Type Id]), 'MEASURE LIST ACTUAL'[Dim Currency Type Id]=6, 'MEASURE LIST ACTUAL'[Dim Time Perspective Id]=VALUES('SWITCH TIME PERSPECTIVE'[Row Index])) // This measure is preselected to switch between the two different measures for 'Actual XR2 (YTD Based)'.
Selected Bud Measure	Y	N	Identify selected version of measure for Budget	N/A	N	CALCULATE(MIN('MEASURE LIST COMPARISON'[Row Index]), ALLEXCEPT('MEASURE LIST COMPARISON','MEASURE LIST COMPARISON'[Dim Comparison Id]), 'MEASURE LIST COMPARISON'[Dim Comparison Id]=2, 'MEASURE LIST COMPARISON'[Dim Currency Type Id]=VALUES('SWITCH CURRENCY TYPE'[Row Index]), 'MEASURE LIST COMPARISON'[Dim Time Perspective Id]=VALUES('SWITCH TIME PERSPECTIVE'[Row Index])) // This measure is preselected to switch between the different benchmark measures for 'Budget'.
Selected CFC Measure	Y	N	Identify selected version of measure for Current Forecast	N/A	N	CALCULATE(MIN('MEASURE LIST COMPARISON'[Row Index]), ALLEXCEPT('MEASURE LIST COMPARISON','MEASURE LIST COMPARISON'[Dim Comparison Id]), 'MEASURE LIST COMPARISON'[Dim Comparison Id]=3, 'MEASURE LIST COMPARISON'[Dim Currency Type Id]=VALUES('SWITCH CURRENCY TYPE'[Row Index]), 'MEASURE LIST COMPARISON'[Dim Time Perspective Id]=VALUES('SWITCH TIME PERSPECTIVE'[Row Index])) // This measure is preselected to switch between the different benchmark measures for 'Current Forecast'.
Selected Comparison Measure	Y	N	Identify selected version of Comparison measures to use as benchmark.	N/A	N	MIN('MEASURE LIST COMPARISON'[Row Index]) // This measure returns the ID (number) of the selected Comparison measures to use as benchmark.
Selected Comparison Switch	Y	N	This measure returns the ID (number) for one of the four available benchmark comparisons (Previous Year, Budget, Current Forecast or Next Forecast). Only mandatory to do a single selection for switch measures to function in case of presenting a comparision measure.	N/A	N	SELECTEDVALUE('SWITCH COMPARISON MEASURE'[Row Index]) // This measure returns the ID (number) for one of the four available benchmark comparisons (Previous Year, Budget, Current Forecast or Next Forecast).
Selected Currency Switch	Y	N	This measure returns the ID (number) for one of the six available currency types. Mandatory to do a single selection for switch measures to function.	N/A	N	SELECTEDVALUE('SWITCH CURRENCY TYPE'[Row Index]) // This measure returns the ID (number) for one of the six available currency types.
Selected DisplayUnit Switch	Y	N	This measure returns the ID (number) for one of the four available display units (None, Thousand, Million or Billions). IF statement is for ensuring a default factor of '1', thereby not mandatory make a selection for the different switch measures to work.	N/A	N	IF(SELECTEDVALUE('SWITCH DISPLAY UNIT'[Factor])=BLANK(),1,SELECTEDVALUE('SWITCH DISPLAY UNIT'[Factor])) // This measure returns the ID (number) for one of the four available display units (None, Thousand, Million or Billions). // IF statement is for ensuring a default factor of '1', thereby not mandatory make a selection for the different switch measures to work.
Selected NFC Measure	Y	N	Identify selected version of measure for Next Forecast	N/A	N	CALCULATE(MIN('MEASURE LIST COMPARISON'[Row Index]), ALLEXCEPT('MEASURE LIST COMPARISON','MEASURE LIST COMPARISON'[Dim Comparison Id]), 'MEASURE LIST COMPARISON'[Dim Comparison Id]=4, 'MEASURE LIST COMPARISON'[Dim Currency Type Id]=VALUES('SWITCH CURRENCY TYPE'[Row Index]), 'MEASURE LIST COMPARISON'[Dim Time Perspective Id]=VALUES('SWITCH TIME PERSPECTIVE'[Row Index])) // This measure is preselected to switch between the different benchmark measures for 'Next Forecast'.
Selected Time Switch	Y	N	This measure returns the ID (number) for one of the two available time perspectives types (Monthly or YTD). Mandatory to do a single selection for switch measures to function.	N/A	N	SELECTEDVALUE('SWITCH TIME PERSPECTIVE'[Row Index]) // This measure returns the ID (number) for one of the two available time perspectives (Period or YTD).
Switch Actual	Y	N	Selects a version of actual measure	N/A	N	[Selected DisplayUnit Switch] * SWITCH([Selected Actual Measure], 1, [ACT], 2, [ACT YTD], 4, [ACT GC], 5, [ACT YTD GC], 7, [ACT XR1 (Period Based)], 8, [ACT YTD XR1 (Period Based)], 10, [ACT XR2 (Period Based)], 11, [ACT YTD XR2 (Period Based)], 13, [ACT XR1 (YTD Based)], 14, [ACT YTD XR1 (YTD Based)], 16, [ACT XR2 (YTD Based)], 17, [ACT YTD XR2 (YTD Based)] ) // Complete list of measures to switch between, the list includes all available ACTUAL measures. // NOTE: This measures can have performance issue. Then instead use the other 'Switch Actual ...'-measures with shorter list of switches, like eg 'Switch Actual (Node and Group)', 'Switch Actual XR1 (Period Based)' and so on.
Switch Actual (Node and Group)	Y	N	Selects a version of actual measure when switching between Node and Group currency in Node based analysis	N/A	N	[Selected DisplayUnit Switch] * SWITCH([Selected Actual Measure], 1, [ACT], 2, [ACT YTD], 4, [ACT GC], 5, [ACT YTD GC] ) // To switch between Actuals calculated in NODE or GROUP currency and MONTHLY or YTD values. // This is the best selection of switch measure if only to switch between Node o Group currency.
Switch Actual XR1 (Period Based)	Y	N	Selects a version of Actual XR1 (Period Based) measure	N/A	N	[Selected DisplayUnit Switch] * SWITCH([Selected Actual XR1 (Period Based) Measure], 7, [ACT XR1 (Period Based)], 8, [ACT YTD XR1 (Period Based)] ) // This switch measure is the best selection when to only switch between the two different 'XR1 (Period Based)' ACTUAL measures. // Prerequisite: When using this measure there is no need to filter on 'Dim Currency Type Id' from table 'MEASURE LIST ACTUAL', that is already done in the [Selected Actual XR1 (Period Based) Measure]
Switch Actual XR1 (YTD Based)	Y	N	Selects a version of Actual XR1 (YTD Based) measure	N/A	N	[Selected DisplayUnit Switch] * SWITCH([Selected Actual XR1 (YTD Based) Measure], 13, [ACT XR1 (YTD Based)], 14, [ACT YTD XR1 (YTD Based)] ) // This switch measure is the best selection when to only switch between the two different 'XR1 (YTD Based)' ACTUAL measures. // Prerequisite: When using this measure there is no need to filter on 'Dim Currency Type Id' from table 'MEASURE LIST ACTUAL', that is already done in the [Selected Actual XR1 (YTD Based) Measure]
Switch Actual XR1 XR2 Diff (Period Based)	Y	N	Calculates the difference between selected Actual XR1 and Actual XR2 measure (Period Based) method	N/A	N	[Switch Actual XR1 (Period Based)] - [Switch Actual XR2 (Period Based)] // Calculates the difference for ACTUAL when to compare XR1 (Period Based) to XR2 (Period Based)
Switch Actual XR1 XR2 Diff (Period Based)(%)	Y	N	Calculates the (%) difference between selected Actual XR1 and Actual XR2 measure (Period Based) method	N/A	N	DIVIDE([Switch Actual XR1 XR2 Diff (Period Based)],ABS([Switch Actual XR2 (Period Based)]), Blank()) // Calculates the % difference for ACTUAL when to compare XR1 (Period Based) to XR2 (Period Based)
Switch Actual XR1 XR2 Diff (YTD Based)	Y	N	Calculates the difference between selected Actual XR1 and Actual XR2 measure (YTD Based) method	N/A	N	[Switch Actual XR1 (YTD Based)] - [Switch Actual XR2 (YTD Based)] // Calculates the difference for ACTUAL when to compare XR1 (YTD Based) to XR2 (YTD Based)
Switch Actual XR1 XR2 Diff (YTD Based)(%)	Y	N	Calculates the (%) difference between selected Actual XR1 and Actual XR2 measure (YTD Based) method	N/A	N	DIVIDE([Switch Actual XR1 XR2 Diff (YTD Based)],ABS([Switch Actual XR2 (YTD Based)]), Blank()) // Calculates the % difference for ACTUAL when to compare XR1 (YTD Based) to XR2 (YTD Based)
Switch Actual XR2 (Period Based)	Y	N	Selects a version of Actual XR2 (Period Based) measure	N/A	N	[Selected DisplayUnit Switch] * SWITCH([Selected Actual XR2 (Period Based) Measure], 10, [ACT XR2 (Period Based)], 11, [ACT YTD XR2 (Period Based)] ) // This switch measure is the best selection when to only switch between the two different 'XR2 (Period Based)' ACTUAL measures. // Prerequisite: When using this measure there is no need to filter on 'Dim Currency Type Id' from table 'MEASURE LIST ACTUAL', that is already done in the [Selected Actual XR2 (Period Based) Measure]
Switch Actual XR2 (YTD Based)	Y	N	Selects a version of Actual XR2 (YTD Based) measure	N/A	N	[Selected DisplayUnit Switch] * SWITCH([Selected Actual XR2 (YTD Based) Measure], 16, [ACT XR2 (YTD Based)], 17, [ACT YTD XR2 (YTD Based)] ) // This switch measure is the best selection when to only switch between the two different 'XR2 (YTD Based)' ACTUAL measures. // Prerequisite: When using this measure there is no need to filter on 'Dim Currency Type Id' from table 'MEASURE LIST ACTUAL', that is already done in the [Selected Actual XR2 (YTD Based) Measure]
Switch Comp (ActPY)	Y	N	Selects a version of actual previous year measure	N/A	N	[Selected DisplayUnit Switch] * SWITCH([Selected ActPY Measure], 1, [ACT PY], 5, [ACT PY GC], 9, [ACT PY XR1 (Period Based)], 13, [ACT PY XR2 (Period Based)], 17, [ACT PY XR1 (YTD Based)], 21, [ACT PY XR2 (YTD Based)], 25, [ACT PY YTD], 29, [ACT PY YTD GC], 33, [ACT PY YTD XR1 (Period Based)], 37, [ACT PY YTD XR2 (Period Based)], 41, [ACT PY YTD XR1 (YTD Based)], 45, [ACT PY YTD XR2 (YTD Based)] ) // To be used when to switch between all the different 'ACT PY' measures as the benchmark for comparison.
Switch Comp (Bud)	Y	N	Selects a version of budget measure	N/A	N	[Selected DisplayUnit Switch] * SWITCH([Selected Bud Measure], 2, [BUD], 6, [BUD GC], 10, [BUD XR1 (Period Based)], 14, [BUD XR2 (Period Based)], 18, [BUD XR1 (YTD Based)], 22, [BUD XR2 (YTD Based)], 26, [BUD YTD], 30, [BUD YTD GC], 34, [BUD YTD XR1 (Period Based)], 38, [BUD YTD XR2 (Period Based)], 42, [BUD YTD XR1 (YTD Based)], 46, [BUD YTD XR2 (YTD Based)] ) // To be used when to switch between all the different 'BUD' measures as the benchmark for comparison.
Switch Comp (CFC)	Y	N	Selects a version of current forecast measure	N/A	N	[Selected DisplayUnit Switch] * SWITCH([Selected CFC Measure], 3, [CFC], 7, [CFC GC], 11, [CFC XR1 (Period Based)], 15, [CFC XR2 (Period Based)], 19, [CFC XR1 (YTD Based)], 23, [CFC XR2 (YTD Based)], 27, [CFC YTD], 31, [CFC YTD GC], 35, [CFC YTD XR1 (Period Based)], 39, [CFC YTD XR2 (Period Based)], 43, [CFC YTD XR1 (YTD Based)], 47, [CFC YTD XR2 (YTD Based)] ) // To be used when to switch between all the different 'CFC' measures as the benchmark for comparison.
Switch Comp (NFC)	Y	N	Selects a version of next forecast measure	N/A	N	[Selected DisplayUnit Switch] * SWITCH([Selected NFC Measure], 4, [NFC], 8, [NFC GC], 12, [NFC XR1 (Period Based)], 16, [NFC XR2 (Period Based)], 20, [NFC XR1 (YTD Based)], 24, [NFC XR2 (YTD Based)], 28, [NFC YTD], 32, [NFC YTD GC], 36, [NFC YTD XR1 (Period Based)], 40, [NFC YTD XR2 (Period Based)], 44, [NFC YTD XR1 (YTD Based)], 48, [NFC YTD XR2 (YTD Based)] ) // To be used when to switch between all the different 'NFC' measures as the benchmark for comparison.
Switch Comp (Node and Group)	Y	N	Selects a version of Node or Group currency measure	N/A	N	[Selected DisplayUnit Switch] * SWITCH([Selected Comparison Measure], 1, [ACT PY], 2, [BUD], 3, [CFC], 4, [NFC], 5, [ACT PY GC], 6, [BUD GC], 7, [CFC GC], 8, [NFC GC], 25, [ACT PY YTD], 26, [BUD YTD], 27, [CFC YTD], 28, [NFC YTD], 29, [ACT PY YTD GC], 30, [BUD YTD GC], 31, [CFC YTD GC], 32, [NFC YTD GC] ) // To switch between different benchmarks when comparison is on NODE or GROUP currency and MONTHLY or YTD values. // This is the best selection of switch measure if only to switch between comparison measures in Node o Group currency.
Switch Comp XR1 (Period Based)	Y	N	Selects a version of Comparision XR1 (Period Based) measure	N/A	N	[Selected DisplayUnit Switch] * SWITCH([Selected Comparison Measure], 9, [ACT PY XR1 (Period Based)], 10, [BUD XR1 (Period Based)], 11, [CFC XR1 (Period Based)], 12, [NFC XR1 (Period Based)], 33, [ACT PY YTD XR1 (Period Based)], 34, [BUD YTD XR1 (Period Based)], 35, [CFC YTD XR1 (Period Based)], 36, [NFC YTD XR1 (Period Based)] ) // To switch between different benchmarks when comparison is on XR1 (Period Based) measures. // This is the best selection of switch measure if only to switch between comparison XR1 (Period Based) measures.
Switch Comp XR1 (YTD Based)	Y	N	Selects a version of Comparision XR1 (YTD Based) measure	N/A	N	[Selected DisplayUnit Switch] * SWITCH([Selected Comparison Measure], 17, [ACT PY XR1 (YTD Based)], 18, [BUD XR1 (YTD Based)], 19, [CFC XR1 (YTD Based)], 20, [NFC XR1 (YTD Based)], 41, [ACT PY YTD XR1 (YTD Based)], 42, [BUD YTD XR1 (YTD Based)], 43, [CFC YTD XR1 (YTD Based)], 44, [NFC YTD XR1 (YTD Based)] ) // To switch between different benchmarks when comparison is on XR1 (YTD Based) measures. // This is the best selection of switch measure if only to switch between comparison XR1 (YTD Based) measures.
Switch Comp XR2 (Period Based)	Y	N	Selects a version of Comparision XR2 (Period Based) measure	N/A	N	[Selected DisplayUnit Switch] * SWITCH([Selected Comparison Measure], 13, [ACT PY XR2 (Period Based)], 14, [BUD XR2 (Period Based)], 15, [CFC XR2 (Period Based)], 16, [NFC XR2 (Period Based)], 37, [ACT PY YTD XR2 (Period Based)], 38, [BUD YTD XR2 (Period Based)], 39, [CFC YTD XR2 (Period Based)], 40, [NFC YTD XR2 (Period Based)] ) // To switch between different benchmarks when comparison is on XR2 (Period Based) measures. // This is the best selection of switch measure if only to switch between comparison XR2 (Period Based) measures.
Switch Comp XR2 (YTD Based)	Y	N	Selects a version of Comparision XR2 (YTD Based) measure	N/A	N	[Selected DisplayUnit Switch] * SWITCH([Selected Comparison Measure], 21, [ACT PY XR2 (YTD Based)], 22, [BUD XR2 (YTD Based)], 23, [CFC XR2 (YTD Based)], 24, [NFC XR2 (YTD Based)], 45, [ACT PY YTD XR2 (YTD Based)], 46, [BUD YTD XR2 (YTD Based)], 47, [CFC YTD XR2 (YTD Based)], 48, [NFC YTD XR2 (YTD Based)] ) // To switch between different benchmarks when comparison is on XR2 (YTD Based) measures. // This is the best selection of switch measure if only to switch between comparison XR2 (YTD Based) measures.
Switch Comparison	Y	N	Selects a version among all comparison measures	N/A	N	[Selected DisplayUnit Switch] * SWITCH([Selected Comparison Measure], 1, [ACT PY], 2, [BUD], 3, [CFC], 4, [NFC], 5, [ACT PY GC], 6, [BUD GC], 7, [CFC GC], 8, [NFC GC], 9, [ACT PY XR1 (Period Based)], 10, [BUD XR1 (Period Based)], 11, [CFC XR1 (Period Based)], 12, [NFC XR1 (Period Based)], 13, [ACT PY XR2 (Period Based)], 14, [BUD XR2 (Period Based)], 15, [CFC XR2 (Period Based)], 16, [NFC XR2 (Period Based)], 17, [ACT PY XR1 (YTD Based)], 18, [BUD XR1 (YTD Based)], 19, [CFC XR1 (YTD Based)], 20, [NFC XR1 (YTD Based)], 21, [ACT PY XR2 (YTD Based)], 22, [BUD XR2 (YTD Based)], 23, [CFC XR2 (YTD Based)], 24, [NFC XR2 (YTD Based)], 25, [ACT PY YTD], 26, [BUD YTD], 27, [CFC YTD], 28, [NFC YTD], 29, [ACT PY YTD GC], 30, [BUD YTD GC], 31, [CFC YTD GC], 32, [NFC YTD GC], 33, [ACT PY YTD XR1 (Period Based)], 34, [BUD YTD XR1 (Period Based)], 35, [CFC YTD XR1 (Period Based)], 36, [NFC YTD XR1 (Period Based)], 37, [ACT PY YTD XR2 (Period Based)], 38, [BUD YTD XR2 (Period Based)], 39, [CFC YTD XR2 (Period Based)], 40, [NFC YTD XR2 (Period Based)], 41, [ACT PY YTD XR1 (YTD Based)], 42, [BUD YTD XR1 (YTD Based)], 43, [CFC YTD XR1 (YTD Based)], 44, [NFC YTD XR1 (YTD Based)], 45, [ACT PY YTD XR2 (YTD Based)], 46, [BUD YTD XR2 (YTD Based)], 47, [CFC YTD XR2 (YTD Based)], 48, [NFC YTD XR2 (YTD Based)] ) // Complete list of measures to switch between, the list includes all available COMPARISON measures. // NOTE: For performance reason this measures should not be used!!! Instead use the other 'Switch Comp...'-measures with shorter list of switches, like eg 'Switch Comp (Node and Group)', 'Switch Comp XR1 (Period Based)' and so on.
Switch Diff	Y	N	Calculates the difference between selected Actual and Comparison measure	N/A	N	IF([HasOneAccountPeriod] = FALSE(), BLANK(), [Switch Actual] - [Switch Comparison]) // Calculates the difference between the selected Actual-measure and the selected Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals. // NOTE: For performance reason this measures should not be used!!! Instead use the other 'Switch Diff ...'-measures built from a shorter list of switches, like eg 'Switch Diff (Act PY)', 'Switch Diff XR1 (Period Based)' and so on.
Switch Diff (%)	Y	N	Calculates the (%) difference between selected Actual and Comparison measure	N/A	N	DIVIDE([Switch Diff],ABS([Switch Comparison]), Blank()) // Calculates the % difference between the selected Actual-measure and the selected Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals. // NOTE: For performance reason this measures should not be used!!! Instead use the other 'Diff(%) ...'-measures built from a shorter list of switches, like eg 'Diff (Act PY)(%)', 'Switch Diff XR1 (Period Based)(%)' and so on.
Switch Diff (ActPY)	Y	N	Calculates the difference between selected Actual and Act PY measure	N/A	N	IF([HasOneAccountPeriod] = FALSE(), BLANK(), [Switch Actual] - [Switch Comp (ActPY)]) // Calculates the difference between the selected Actual-measure and the selected (ACT PY) Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.
Switch Diff (ActPY)(%)	Y	N	Calculates the (%) difference between selected Actual and Act PY measure	N/A	N	DIVIDE([Switch Diff (ActPY)],ABS([Switch Comp (ActPY)]), Blank()) // Calculates the % difference between the selected Actual-measure and the selected (ACT PY) Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.
Switch Diff (Bud)	Y	N	Calculates the difference between selected Actual and Budget measure	N/A	N	IF([HasOneAccountPeriod] = FALSE(), BLANK(), [Switch Actual] - [Switch Comp (Bud)]) // Calculates the difference between the selected Actual-measure and the selected (BUD) Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.
Switch Diff (Bud)(%)	Y	N	Calculates the (%) difference between selected Actual and Budget measure	N/A	N	DIVIDE([Switch Diff (Bud)],ABS([Switch Comp (Bud)]), Blank()) // Calculates the % difference between the selected Actual-measure and the selected (BUD) Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.
Switch Diff (CFC)	Y	N	Calculates the difference between selected Actual and Current Forecast measure	N/A	N	IF([HasOneAccountPeriod] = FALSE(), BLANK(), [Switch Actual] - [Switch Comp (CFC)]) // Calculates the difference between the selected Actual-measure and the selected (CFC) Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.
Switch Diff (CFC)(%)	Y	N	Calculates the (%) difference between selected Actual and Current Forecast measure	N/A	N	DIVIDE([Switch Diff (CFC)],ABS([Switch Comp (CFC)]), Blank()) // Calculates the % difference between the selected Actual-measure and the selected (CFC) Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.
Switch Diff (NFC)	Y	N	Calculates the difference between selected Actual and Next Forecast measure	N/A	N	IF([HasOneAccountPeriod] = FALSE(), BLANK(), [Switch Actual] - [Switch Comp (NFC)]) // Calculates the difference between the selected Actual-measure and the selected (NFC) Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.
Switch Diff (NFC)(%)	Y	N	Calculates the (%) difference between selected Actual and Next Forecast measure	N/A	N	DIVIDE([Switch Diff (NFC)],ABS([Switch Comp (NFC)]), Blank()) // Calculates the % difference between the selected Actual-measure and the selected (NFC) Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.
Switch Diff (Node and Group)	Y	N	Calculates the difference between selected year and previous year for selected Node or Group currency measure	N/A	N	IF([HasOneAccountPeriod] = FALSE(), BLANK(), [Switch Actual (Node and Group)] - [Switch Comp (Node and Group)]) // Calculates the difference between the selected (Node or Group) Actual-measure and the selected (Node or Group) Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.
Switch Diff (Node and Group)(%)	Y	N	Calculates the (%) difference between selected year and previous year for selected Node or Group currency measure	N/A	N	DIVIDE([Switch Diff (Node and Group)],ABS([Switch Comp (Node and Group)]), Blank()) // Calculates the % difference between the selected (Node or Group) Actual-measure and the selected (Node or Group) Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.
Switch Diff XR1 (Period Based)	Y	N	Calculates the difference between selected Actual XR1 (Period Based) and Comparision XR1 (Period Based) measure	N/A	N	IF([HasOneAccountPeriod] = FALSE(), BLANK(), [Switch Actual XR1 (Period Based)] - [Switch Comp XR1 (Period Based)]) // Calculates the difference between the selected 'XR1 (Period Based)' Actual-measure and the selected 'XR1 (Period Based)' Comparison measure.
Switch Diff XR1 (Period Based)(%)	Y	N	Calculates the (%) difference between selected Actual XR1 (Period Based) and Comparision XR1 (Period Based) measure	N/A	N	DIVIDE([Switch Diff XR1 (Period Based)],ABS([Switch Comp XR1 (Period Based)]), Blank()) // Calculates the % difference between the selected 'XR1 (Period Based)' Actual-measure and the selected 'XR1 (Period Based)' Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.
Switch Diff XR1 (YTD Based)	Y	N	Calculates the difference between selected Actual XR1 (YTD Based) and Comparision XR1 (YTD Based) measure	N/A	N	IF([HasOneAccountPeriod] = FALSE(), BLANK(), [Switch Actual XR1 (YTD Based)] - [Switch Comp XR1 (YTD Based)]) // Calculates the difference between the selected 'XR1 (YTD Based)' Actual-measure and the selected 'XR1 (YTD Based)' Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.
Switch Diff XR1 (YTD Based)(%)	Y	N	Calculates the (%) difference between selected Actual XR1 (YTD Based) and Comparision XR1 (YTD Based) measure	N/A	N	DIVIDE([Switch Diff XR1 (YTD Based)],ABS([Switch Comp XR1 (YTD Based)]), Blank()) // Calculates the % difference between the selected 'XR1 (YTD Based)' Actual-measure and the selected 'XR1 (YTD Based)' Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.
Switch Diff XR2 (Period Based)	Y	N	Calculates the difference between selected Actual XR2 (Period Based) and Comparision XR1 (Period Based) measure	N/A	N	IF([HasOneAccountPeriod] = FALSE(), BLANK(), [Switch Actual XR2 (Period Based)] - [Switch Comp XR2 (Period Based)]) // Calculates the difference between the selected 'XR2 (Period Based)' Actual-measure and the selected 'XR2 (Period Based)' Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.
Switch Diff XR2 (Period Based)(%)	Y	N	Calculates the (%) difference between selected Actual XR2 (Period Based) and Comparision XR1 (Period Based) measure	N/A	N	DIVIDE([Switch Diff XR2 (Period Based)],ABS([Switch Comp XR2 (Period Based)]), Blank()) // Calculates the % difference between the selected 'XR2 (Period Based)' Actual-measure and the selected 'XR2 (Period Based)' Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.
Switch Diff XR2 (YTD Based)	Y	N	Calculates the difference between selected Actual XR2 (YTD Based) and Comparision XR1 (YTD Based) measure	N/A	N	IF([HasOneAccountPeriod] = FALSE(), BLANK(), [Switch Actual XR2 (YTD Based)] - [Switch Comp XR2 (YTD Based)]) // Calculates the difference between the selected 'XR2 (YTD Based)' Actual-measure and the selected 'XR2 (YTD Based)' Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.
Switch Diff XR2 (YTD Based)(%)	Y	N	Calculates the (%) difference between selected Actual XR2 (YTD Based) and Comparision XR1 (YTD Based) measure	N/A	N	DIVIDE([Switch Diff XR2 (YTD Based)],ABS([Switch Comp XR2 (YTD Based)]), Blank()) // Calculates the % difference between the selected 'XR2 (YTD Based)' Actual-measure and the selected 'XR2 (YTD Based)' Comparison measure. // This measure can only presents values for a single period, not totals for example annual totals.

Time Intelligence Measures

Time based measures are calculated in the cube with respect to other measures. The table below defines the meaning/definition of the different time measures. These measures need to be used with a specific time dimension hierarchy [REPORTING_DATE].[RepDateMFHy].

Measure	Meaning
YTD	Aggregated value for current month in current year. E.g. for period 202010 Ytd represents sum of periods 202000-202010.
R12	For a given period, the sum all months from one year back up to the previous month. E.g. Rolling 12 for 202010 is the sum of months 201910 - 202009
PY	Previous Year The value of the corresponding month one year back. E.g. for month 202010, the value of month 201910.
YTD PY	Year to Date Previous Year Aggregated value for corresponding month one year back. E.g. for month 202010 YTD Previous Year represents sum of months 201901-201910.
R12 PY	Rolling 12 (completed) Months Previous Year For a given month, first going one year back, then taking the sum of all months from one (more) year back up to the previous month. E.g. for month 202010 the sum of month 201810-201909
Avg XXX Ytd	Sum XXX YTD/Count XXX YTD
Avg XXX R12	Sum XXX R12/Count XXX R12
XXX % YTD	Count XXX YTD/Count YYY YTD
XXX % R12	Count XXX R12/Count XXX R12

USED BY MODEL(S)

Model Name	Product Area
Group Reporting

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Additional information can be found in the online documentation of Information Sources.

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
STRUCTURE BASED ANALYSIS MEASURES