Model: General Ledger - Specifications for Fact Table: IL ANALYSIS MEASURES

On this page you will find the specifications regarding the Model: General Ledger and Fact Table: IL ANALYSIS MEASURES.

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.
Measure 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	Measure Expression
ACT OB IL	Y	Y	IL version of same GL measure		N	IF(ISBLANK([ACT YTD IL]) , BLANK() ,([ACT YTD IL] - [ACT IL])) // ACT YTD IL - ACT IL = Opening balance in Accounting Currency, use Reporting calendar.
ACTOBPeriodZero IL	Y	Y	IL version of same GL measure		N	//Calulcates the incoming balance related to [ACT IL], acc period 0, as defined in the underlying data source // The idea is to calculate the same value for all periods VAR UntilDate = MAX('REPORTING PERIOD'[Period Until Date]) VAR LastDatePY = MAX('REPORTING PERIOD'[Max Reporting Date PY]) VAR DiffInDays = DATEDIFF(LastDatePY, UntilDate, DAY) RETURN CALCULATE ( // go back to last data in previous reporting year + 1 [ACT OB IL], DATEADD('REPORTING PERIOD'[ID],-DiffInDays+1, DAY) )
BUD OB IL	Y	Y	IL version of same GL measure		N	IF(ISBLANK([BUD YTD IL]) , BLANK() ,([BUD YTD IL] - [BUD IL])) // BUD YTD IL - BUD IL = Opening balance in Accounting Currency, use Reporting calendar.
BUDOBPeriodZero IL	Y	Y	IL version of same GL measure		N	//Calulcates the incoming balance related to [BUD IL], acc period 0, as defined in the underlying data source // The idea is to calculate the same value for all periods VAR UntilDate = MAX('REPORTING PERIOD'[Period Until Date]) VAR LastDatePY = MAX('REPORTING PERIOD'[Max Reporting Date PY]) VAR DiffInDays = DATEDIFF(LastDatePY, UntilDate, DAY) RETURN CALCULATE ( // go back to last data in previous reporting year + 1 [BUD OB IL], DATEADD('REPORTING PERIOD'[ID],-DiffInDays+1, DAY) )
CFC OB IL	Y	Y	IL version of same GL measure		N	IF(ISBLANK([CFC YTD IL]) , BLANK() ,([CFC YTD IL] - [CFC IL])) // CFC YTD IL - CFC IL = Opening balance in Accounting Currency, use Reporting calendar.
CFCOBPeriodZero IL	Y	Y	IL version of same GL measure		N	//Calulcates the incoming balance related to [CFC IL], acc period 0, as defined in the underlying data source // The idea is to calculate the same value for all periods VAR UntilDate = MAX('REPORTING PERIOD'[Period Until Date]) VAR LastDatePY = MAX('REPORTING PERIOD'[Max Reporting Date PY]) VAR DiffInDays = DATEDIFF(LastDatePY, UntilDate, DAY) RETURN CALCULATE ( // go back to last data in previous reporting year + 1 [CFC OB IL], DATEADD('REPORTING PERIOD'[ID],-DiffInDays+1, DAY) )
NFC OB IL	Y	Y	IL version of same GL measure		N	IF(ISBLANK([NFC YTD IL]) , BLANK() ,([NFC YTD IL] - [NFC IL])) // NFC YTD IL - NFC IL = Opening balance in Accounting Currency, use Reporting calendar.
NFCOBPeriodZero IL	Y	Y	IL version of same GL measure		N	//Calulcates the incoming balance related to [NFC IL], acc period 0, as defined in the underlying data source // The idea is to calculate the same value for all periods VAR UntilDate = MAX('REPORTING PERIOD'[Period Until Date]) VAR LastDatePY = MAX('REPORTING PERIOD'[Max Reporting Date PY]) VAR DiffInDays = DATEDIFF(LastDatePY, UntilDate, DAY) RETURN CALCULATE ( // go back to last data in previous reporting year + 1 [NFC OB IL], DATEADD('REPORTING PERIOD'[ID],-DiffInDays+1, DAY) )
ACT PY IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // ACTUAL IL PREVIOUS YEAR in Accounting Currency, use Reporting calendar.
BUD PY IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // BUDGET IL PREVIOUS YEAR in Accounting Currency, use Reporting calendar.
ACT PY R12 IL	Y	Y	IL version of same GL measure		N	CALCULATE ([ACT R12 IL], DATEADD ( 'REPORTING PERIOD'[ID], -12, MONTH )) // ACT PY R12 IL: This measure displays the last available value if presented for multiple periods, eg by quarter then the value in quarter 1 will be the value from March.
BUD PY R12 IL	Y	Y	IL version of same GL measure		N	CALCULATE ([BUD R12 IL], DATEADD ( 'REPORTING PERIOD'[ID], -12, MONTH )) // BUD PY R12 IL: This measure displays the last available value if presented for multiple periods, eg by quarter then the value in quarter 1 will be the value from March.
ACT PY YTD IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT YTD IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // Previous year ACTUAL IL YTD value in Accounting Currency, use Reporting calendar.
BUD PY YTD IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD YTD IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // Previous year BUDGET IL YTD value in Accounting Currency, use Reporting calendar.
ACT R12 IL	Y	Y	IL version of same GL measure		N	VAR First_Period = CALCULATE(MAX('REPORTING PERIOD'[Reporting Year Period]), DATEADD('REPORTING PERIOD'[ID], -11, MONTH)) VAR Last_Period = MAX ( 'REPORTING PERIOD'[Reporting Year Period] ) RETURN CALCULATE ( [ACT IL], FILTER ( ALL ( 'REPORTING PERIOD' ), 'REPORTING PERIOD'[Reporting Year Period] >= First_Period && 'REPORTING PERIOD'[Reporting Year Period] <= Last_Period ) ) // ACTUAL IL Rolling 12: This measure displays the last available value if presented for multiple periods, eg by quarter then the value in quarter 1 will be the value from March.
BUD R12 IL	Y	Y	IL version of same GL measure		N	VAR First_Period = CALCULATE(MAX('REPORTING PERIOD'[Reporting Year Period]), DATEADD('REPORTING PERIOD'[ID], -11, MONTH)) VAR Last_Period = MAX ( 'REPORTING PERIOD'[Reporting Year Period] ) RETURN CALCULATE ( [BUD IL], FILTER ( ALL ( 'REPORTING PERIOD' ), 'REPORTING PERIOD'[Reporting Year Period] >= First_Period && 'REPORTING PERIOD'[Reporting Year Period] <= Last_Period ) ) // BUDGET IL Rolling 12: This measure displays the last available value if presented for multiple periods, eg by quarter then the value in quarter 1 will be the value from March.
CFC R12 IL	Y	Y	IL version of same GL measure		N	VAR First_Period = CALCULATE(MAX('REPORTING PERIOD'[Reporting Year Period]), DATEADD('REPORTING PERIOD'[ID], -11, MONTH)) VAR Last_Period = MAX ( 'REPORTING PERIOD'[Reporting Year Period] ) RETURN CALCULATE ( [CFC IL], FILTER ( ALL ( 'REPORTING PERIOD' ), 'REPORTING PERIOD'[Reporting Year Period] >= First_Period && 'REPORTING PERIOD'[Reporting Year Period] <= Last_Period ) ) // CURRENT FORECAST IL Rolling 12: This measure displays the last available value if presented for multiple periods, eg by quarter then the value in quarter 1 will be the value from March.
NFC R12 IL	Y	Y	IL version of same GL measure		N	VAR First_Period = CALCULATE(MAX('REPORTING PERIOD'[Reporting Year Period]), DATEADD('REPORTING PERIOD'[ID], -11, MONTH)) VAR Last_Period = MAX ( 'REPORTING PERIOD'[Reporting Year Period] ) RETURN CALCULATE ( [NFC IL], FILTER ( ALL ( 'REPORTING PERIOD' ), 'REPORTING PERIOD'[Reporting Year Period] >= First_Period && 'REPORTING PERIOD'[Reporting Year Period] <= Last_Period ) ) // NEXT FORECAST IL Rolling 12: This measure displays the last available value if presented for multiple periods, eg by quarter then the value in quarter 1 will be the value from March.
ACT Credit YTD IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT Credit IL], DATESYTD('REPORTING PERIOD'[ID])) + CALCULATE(SUM('IL ANALYSIS'[ACT_OB_PERIOD_CREDIT_DOM]), DATESYTD('REPORTING PERIOD'[ID])) // ACTUAL CREDIT IL YTD in Accounting Currency, use Reporting calendar.
ACT Debit YTD IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT Debit IL], DATESYTD('REPORTING PERIOD'[ID])) + CALCULATE(SUM('IL ANALYSIS'[ACT_OB_PERIOD_DEBET_DOM]), DATESYTD('REPORTING PERIOD'[ID])) // ACTUAL DEBIT IL YTD in Accounting Currency, use Reporting calendar.
ACT YTD IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT IL], DATESYTD('REPORTING PERIOD'[ID])) + CALCULATE(SUM('IL ANALYSIS'[ACT_OB_PERIOD_DOM]), DATESYTD('REPORTING PERIOD'[ID])) // ACTUAL IL YTD in Accounting Currency, use Reporting calendar.
BUD YTD IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD IL], DATESYTD('REPORTING PERIOD'[ID])) + CALCULATE(SUM('IL ANALYSIS'[BUD_OB_PERIOD_DOM]), DATESYTD('REPORTING PERIOD'[ID])) // BUDGET IL YTD in Accounting Currency, use Reporting calendar.
CFC YTD IL	Y	Y	IL version of same GL measure		N	CALCULATE([CFC IL], DATESYTD('REPORTING PERIOD'[ID])) + CALCULATE(SUM('IL ANALYSIS'[CFC_OB_PERIOD_DOM]), DATESYTD('REPORTING PERIOD'[ID])) // CURRENT FORECAST IL YTD in Accounting Currency, use Reporting calendar.
NFC YTD IL	Y	Y	IL version of same GL measure		N	CALCULATE([NFC IL], DATESYTD('REPORTING PERIOD'[ID])) + CALCULATE(SUM('IL ANALYSIS'[NFC_OB_PERIOD_DOM]), DATESYTD('REPORTING PERIOD'[ID])) // NEXT FORECAST IL YTD in Accounting Currency, use Reporting calendar.
ACT Credit IL	Y	N	IL version of same GL measure		N	SUM('IL ANALYSIS'[ACT_PERIOD_CREDIT_DOM]) // ACTUAL CREDIT IL in Accounting Currency, use Reporting calendar.
ACT Debit IL	Y	N	IL version of same GL measure		N	SUM('IL ANALYSIS'[ACT_PERIOD_DEBET_DOM]) // ACTUAL DEBIT IL in Accounting Currency, use Reporting calendar.
BUD IL	Y	N	IL version of same GL measure		N	SUM('IL ANALYSIS'[BUD_PERIOD_DOM]) // BUDGET IL in Accounting Currency, use Reporting calendar.
CFC IL	Y	N	IL version of same GL measure		N	SUM('IL ANALYSIS'[CFC_PERIOD_DOM]) // CURRENT FORECAST IL in Accounting Currency, use Reporting calendar.
NFC IL	Y	N	IL version of same GL measure		N	SUM('IL ANALYSIS'[NFC_PERIOD_DOM]) // NEXT FORECAST IL in Accounting Currency, use Reporting calendar.
Switch Actual IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected Actual Measure], "ACT", [ACT IL], "ACT YTD", [ACT YTD IL], "ACT R12", [ACT R12 IL], "ACT Trans", [ACT Trans IL], "ACT YTD Trans", [ACT YTD Trans IL], "ACT R12 Trans", [ACT R12 Trans IL], "ACT XR1 (Period Based)", [ACT XR1 (Period Based) IL], "ACT YTD XR1 (Period Based)", [ACT YTD XR1 (Period Based) IL], "ACT R12 XR1 (Period Based)", [ACT R12 XR1 (Period Based) IL], "ACT XR2 (Period Based)", [ACT XR2 (Period Based) IL], "ACT YTD XR2 (Period Based)", [ACT YTD XR2 (Period Based) IL], "ACT R12 XR2 (Period Based)", [ACT R12 XR2 (Period Based) IL], "ACT XR1 (YTD Based)", [ACT XR1 (YTD Based) IL], "ACT YTD XR1 (YTD Based)", [ACT YTD XR1 (YTD Based) IL], "ACT R12 XR1 (YTD Based)", [ACT R12 XR1 (YTD Based) IL], "ACT XR2 (YTD Based)", [ACT XR2 (YTD Based) IL], "ACT YTD XR2 (YTD Based)", [ACT YTD XR2 (YTD Based) IL], "ACT R12 XR2 (YTD Based)", [ACT R12 XR2 (YTD Based) IL] ) // Complete list of measures to switch between, the list includes all available ACTUAL IL measures. // NOTE: This measures can have performance issue. Then instead use the other 'Switch Actual ...IL'-measures with shorter list of switches, like eg 'Switch XR1 (Period Based) IL' and so on. Best performance is obtained by using a slicer on column 'Actual Measure Name' in table 'MEASURE LIST ACTUAL'. A slicer in which you then choose between the different measure names instead of using slicers on SWITCH CURRENCY TYPE etc. // Mandatory to filter a single value from tables SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Comp (ActPY) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected ActPY Measure], "ACT PY", [ACT PY IL], "ACT PY Trans", [ACT PY Trans IL], "ACT PY XR1 (Period Based)", [ACT PY XR1 (Period Based) IL], "ACT PY XR2 (Period Based)", [ACT PY XR2 (Period Based) IL], "ACT PY XR1 (YTD Based)", [ACT PY XR1 (YTD Based) IL], "ACT PY XR2 (YTD Based)", [ACT PY XR2 (YTD Based) IL], "ACT PY YTD", [ACT PY YTD IL], "ACT PY YTD Trans", [ACT PY YTD Trans IL], "ACT PY YTD XR1 (Period Based)", [ACT PY YTD XR1 (Period Based) IL], "ACT PY YTD XR2 (Period Based)", [ACT PY YTD XR2 (Period Based) IL], "ACT PY YTD XR1 (YTD Based)", [ACT PY YTD XR1 (YTD Based) IL], "ACT PY YTD XR2 (YTD Based)", [ACT PY YTD XR2 (YTD Based) IL], "ACT PY R12", [ACT PY R12 IL], "ACT PY R12 Trans", [ACT PY R12 Trans IL], "ACT PY R12 XR1 (Period Based)", [ACT PY R12 XR1 (Period Based) IL], "ACT PY R12 XR2 (Period Based)", [ACT PY R12 XR2 (Period Based) IL], "ACT PY R12 XR1 (YTD Based)", [ACT PY R12 XR1 (YTD Based) IL], "ACT PY R12 XR2 (YTD Based)", [ACT PY R12 XR2 (YTD Based) IL] ) // To be used when to switch between all the different ACT PY measures as the benchmark for comparison. // Mandatory to filter a single value from tables SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Comp (Bud) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected Bud Measure], "BUD", [BUD IL], "BUD Trans", [BUD Trans IL], "BUD XR1 (Period Based)", [BUD XR1 (Period Based) IL], "BUD XR2 (Period Based)", [BUD XR2 (Period Based) IL], "BUD XR1 (YTD Based)", [BUD XR1 (YTD Based) IL], "BUD XR2 (YTD Based)", [BUD XR2 (YTD Based) IL], "BUD YTD", [BUD YTD IL], "BUD YTD Trans", [BUD YTD Trans IL], "BUD YTD XR1 (Period Based)", [BUD YTD XR1 (Period Based) IL], "BUD YTD XR2 (Period Based)", [BUD YTD XR2 (Period Based) IL], "BUD YTD XR1 (YTD Based)", [BUD YTD XR1 (YTD Based) IL], "BUD YTD XR2 (YTD Based)", [BUD YTD XR2 (YTD Based) IL], "BUD R12", [BUD R12 IL], "BUD R12 Trans", [BUD R12 Trans IL], "BUD R12 XR1 (Period Based)", [BUD R12 XR1 (Period Based) IL], "BUD R12 XR2 (Period Based)", [BUD R12 XR2 (Period Based) IL], "BUD R12 XR1 (YTD Based)", [BUD R12 XR1 (YTD Based) IL], "BUD R12 XR2 (YTD Based)", [BUD R12 XR2 (YTD Based) IL] ) // To be used when to switch between all the different BUDGET measures as the benchmark for comparison. // Mandatory to filter a single value from tables SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Comp (CFC) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected CFC Measure], "CFC", [CFC IL], "CFC Trans", [CFC Trans IL], "CFC XR1 (Period Based)", [CFC XR1 (Period Based) IL], "CFC XR2 (Period Based)", [CFC XR2 (Period Based) IL], "CFC XR1 (YTD Based)", [CFC XR1 (YTD Based) IL], "CFC XR2 (YTD Based)", [CFC XR2 (YTD Based) IL], "CFC YTD", [CFC YTD IL], "CFC YTD Trans", [CFC YTD Trans IL], "CFC YTD XR1 (Period Based)", [CFC YTD XR1 (Period Based) IL], "CFC YTD XR2 (Period Based)", [CFC YTD XR2 (Period Based) IL], "CFC YTD XR1 (YTD Based)", [CFC YTD XR1 (YTD Based) IL], "CFC YTD XR2 (YTD Based)", [CFC YTD XR2 (YTD Based) IL], "CFC R12", [CFC R12 IL], "CFC R12 Trans", [CFC R12 Trans IL], "CFC R12 XR1 (Period Based)", [CFC R12 XR1 (Period Based) IL], "CFC R12 XR2 (Period Based)", [CFC R12 XR2 (Period Based) IL], "CFC R12 XR1 (YTD Based)", [CFC R12 XR1 (YTD Based) IL], "CFC R12 XR2 (YTD Based)", [CFC R12 XR2 (YTD Based) IL] ) // To be used when to switch between all the different CURRENT FORECAST measures as the benchmark for comparison. // Mandatory to filter a single value from tables SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Comp (NFC) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected NFC Measure], "NFC", [NFC IL], "NFC Trans", [NFC Trans IL], "NFC XR1 (Period Based)", [NFC XR1 (Period Based) IL], "NFC XR2 (Period Based)", [NFC XR2 (Period Based) IL], "NFC XR1 (YTD Based)", [NFC XR1 (YTD Based) IL], "NFC XR2 (YTD Based)", [NFC XR2 (YTD Based) IL], "NFC YTD", [NFC YTD IL], "NFC YTD Trans", [NFC YTD Trans IL], "NFC YTD XR1 (Period Based)", [NFC YTD XR1 (Period Based) IL], "NFC YTD XR2 (Period Based)", [NFC YTD XR2 (Period Based) IL], "NFC YTD XR1 (YTD Based)", [NFC YTD XR1 (YTD Based) IL], "NFC YTD XR2 (YTD Based)", [NFC YTD XR2 (YTD Based) IL], "NFC R12", [NFC R12 IL], "NFC R12 Trans", [NFC R12 Trans IL], "NFC R12 XR1 (Period Based)", [NFC R12 XR1 (Period Based) IL], "NFC R12 XR2 (Period Based)", [NFC R12 XR2 (Period Based) IL], "NFC R12 XR1 (YTD Based)", [NFC R12 XR1 (YTD Based) IL], "NFC R12 XR2 (YTD Based)", [NFC R12 XR2 (YTD Based) IL] ) // To be used when to switch between all the different NEXT FORECAST measures as the benchmark for comparison. // Mandatory to filter a single value from tables SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Comparison IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected Comparison Measure], "ACT PY", [ACT PY IL], "BUD", [BUD IL], "CFC", [CFC IL], "NFC", [NFC IL], "ACT PY Trans", [ACT PY Trans IL], "BUD Trans", [BUD Trans IL], "CFC Trans", [CFC Trans IL], "NFC Trans", [NFC Trans IL], "ACT PY XR1 (Period Based)", [ACT PY XR1 (Period Based) IL], "BUD XR1 (Period Based)", [BUD XR1 (Period Based) IL], "CFC XR1 (Period Based)", [CFC XR1 (Period Based) IL], "NFC XR1 (Period Based)", [NFC XR1 (Period Based) IL], "ACT PY XR2 (Period Based)", [ACT PY XR2 (Period Based) IL], "BUD XR2 (Period Based)", [BUD XR2 (Period Based) IL], "CFC XR2 (Period Based)", [CFC XR2 (Period Based) IL], "NFC XR2 (Period Based)", [NFC XR2 (Period Based) IL], "ACT PY XR1 (YTD Based)", [ACT PY XR1 (YTD Based) IL], "BUD XR1 (YTD Based)", [BUD XR1 (YTD Based) IL], "CFC XR1 (YTD Based)", [CFC XR1 (YTD Based) IL], "NFC XR1 (YTD Based)", [NFC XR1 (YTD Based) IL], "ACT PY XR2 (YTD Based)", [ACT PY XR2 (YTD Based) IL], "BUD XR2 (YTD Based)", [BUD XR2 (YTD Based) IL], "CFC XR2 (YTD Based)", [CFC XR2 (YTD Based) IL], "NFC XR2 (YTD Based)", [NFC XR2 (YTD Based) IL], "ACT PY YTD", [ACT PY YTD IL], "BUD YTD", [BUD YTD IL], "CFC YTD", [CFC YTD IL], "NFC YTD", [NFC YTD IL], "ACT PY YTD Trans", [ACT PY YTD Trans IL], "BUD YTD Trans", [BUD YTD Trans IL], "CFC YTD Trans", [CFC YTD Trans IL], "NFC YTD Trans", [NFC YTD Trans IL], "ACT PY YTD XR1 (Period Based)", [ACT PY YTD XR1 (Period Based) IL], "BUD YTD XR1 (Period Based)", [BUD YTD XR1 (Period Based) IL], "CFC YTD XR1 (Period Based)", [CFC YTD XR1 (Period Based) IL], "NFC YTD XR1 (Period Based)", [NFC YTD XR1 (Period Based) IL], "ACT PY YTD XR2 (Period Based)", [ACT PY YTD XR2 (Period Based) IL], "BUD YTD XR2 (Period Based)", [BUD YTD XR2 (Period Based) IL], "CFC YTD XR2 (Period Based)", [CFC YTD XR2 (Period Based) IL], "NFC YTD XR2 (Period Based)", [NFC YTD XR2 (Period Based) IL], "ACT PY YTD XR1 (YTD Based)", [ACT PY YTD XR1 (YTD Based) IL], "BUD YTD XR1 (YTD Based)", [BUD YTD XR1 (YTD Based) IL], "CFC YTD XR1 (YTD Based)", [CFC YTD XR1 (YTD Based) IL], "NFC YTD XR1 (YTD Based)", [NFC YTD XR1 (YTD Based) IL], "ACT PY YTD XR2 (YTD Based)", [ACT PY YTD XR2 (YTD Based) IL], "BUD YTD XR2 (YTD Based)", [BUD YTD XR2 (YTD Based) IL], "CFC YTD XR2 (YTD Based)", [CFC YTD XR2 (YTD Based) IL], "NFC YTD XR2 (YTD Based)", [NFC YTD XR2 (YTD Based) IL], "ACT PY R12", [ACT PY R12 IL], "BUD R12", [BUD R12 IL], "CFC R12", [CFC R12 IL], "NFC R12", [NFC R12 IL], "ACT PY R12 Trans", [ACT PY R12 Trans IL], "BUD R12 Trans", [BUD R12 Trans IL], "CFC R12 Trans", [CFC R12 Trans IL], "NFC R12 Trans", [NFC R12 Trans IL], "ACT PY R12 XR1 (Period Based)", [ACT PY R12 XR1 (Period Based) IL], "BUD R12 XR1 (Period Based)", [BUD R12 XR1 (Period Based) IL], "CFC R12 XR1 (Period Based)", [CFC R12 XR1 (Period Based) IL], "NFC R12 XR1 (Period Based)", [NFC R12 XR1 (Period Based) IL], "ACT PY R12 XR2 (Period Based)", [ACT PY R12 XR2 (Period Based) IL], "BUD R12 XR2 (Period Based)", [BUD R12 XR2 (Period Based) IL], "CFC R12 XR2 (Period Based)", [CFC R12 XR2 (Period Based) IL], "NFC R12 XR2 (Period Based)", [NFC R12 XR2 (Period Based) IL], "ACT PY R12 XR1 (YTD Based)", [ACT PY R12 XR1 (YTD Based) IL], "BUD R12 XR1 (YTD Based)", [BUD R12 XR1 (YTD Based) IL], "CFC R12 XR1 (YTD Based)", [CFC R12 XR1 (YTD Based) IL], "NFC R12 XR1 (YTD Based)", [NFC R12 XR1 (YTD Based) IL], "ACT PY R12 XR2 (YTD Based)", [ACT PY R12 XR2 (YTD Based) IL], "BUD R12 XR2 (YTD Based)", [BUD R12 XR2 (YTD Based) IL], "CFC R12 XR2 (YTD Based)", [CFC R12 XR2 (YTD Based) IL], "NFC R12 XR2 (YTD Based)", [NFC R12 XR2 (YTD Based) IL] ) // Complete list of comparison measures to switch between, the list includes all available COMPARISON measures. // NOTE: This measures can have performance issue. Then instead use the other 'Switch Comp ...IL'-measures with shorter list of switches, like eg Switch Comp (ActPY) IL and so on. Best performance is obtained by using a slicer on column 'Comparison Measure Name' in table 'MEASURE LIST COMPARISON'. A slicer in which you then choose between the different measure names instead of using slicers on SWITCH CURRENCY TYPE etc. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE, SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff IL	Y	N	IL version of same GL measure		N	[Switch Actual IL] - [Switch Comparison IL] // Calculates the difference between the SWITCH ACTUAL IL and the SWITCH COMPARISON IL measures. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE, SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff IL (%)	Y	N	IL version of same GL measure		N	DIVIDE([Switch Diff IL],ABS([Switch Comparison IL]), Blank()) // Calculates the % difference between the SWITCH ACTUAL IL and the SWITCH COMPARISON IL measures. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE, SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (ActPY%) IL	Y	N	IL version of same GL measure		N	DIVIDE([Switch Diff (ActPY) IL],ABS([Switch Comp (ActPY) IL]), Blank()) // Calculates the % difference between the SWITCH ACTUAL IL and the SWITCH COMP (ActPY) IL. // Mandatory to filter a single value from tables SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (ActPY) IL	Y	N	IL version of same GL measure		N	[Switch Actual IL] - [Switch Comp (ActPY) IL] // Calculates the difference between the SWITCH ACTUAL IL and the SWITCH COMP (ActPY) IL. // Mandatory to filter a single value from tables SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (Bud%) IL	Y	N	IL version of same GL measure		N	DIVIDE([Switch Diff (Bud) IL],ABS([Switch Comp (Bud) IL]), Blank()) // Calculates the % difference between the SWITCH ACTUAL IL and the SWITCH COMP (Bud) IL. // Mandatory to filter a single value from tables SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (Bud) IL	Y	N	IL version of same GL measure		N	[Switch Actual IL] - [Switch Comp (Bud) IL] // Calculates the difference between the SWITCH ACTUAL IL and the SWITCH COMP (Bud) IL. // Mandatory to filter a single value from tables SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff XR (Period Based) IL	Y	N	IL version of same GL measure		N	[Switch Actual (XR1 Period Based)] - [Switch Actual (XR2 Period Based)] // Calculates the difference between the SWITCH ACTUAL (XR1 Period Based) and the SWITCH ACTUAL (XR2 Period Based). // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff XR (Period Based) IL (%)	Y	N	IL version of same GL measure		N	DIVIDE([Switch Diff XR (Period Based)],ABS([Switch Actual (XR2 Period Based)]), Blank()) // Calculates the % difference between the SWITCH ACTUAL (XR1 Period Based) and the SWITCH ACTUAL (XR2 Period Based). // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
ACT OB Trans IL	Y	Y	IL version of same GL measure		N	IF(ISBLANK([ACT YTD Trans IL]) , BLANK() ,([ACT YTD Trans IL] - [ACT Trans IL])) // ACT YTD Trans IL - ACT Trans IL = Opening balance in Transaction Currency, use Reporting calendar.
BUD OB Trans IL	Y	Y	IL version of same GL measure		N	IF(ISBLANK([BUD YTD Trans IL]) , BLANK() ,([BUD YTD Trans IL] - [BUD Trans IL])) // BUD YTD Trans IL - BUD Trans IL = Opening balance in Transaction Currency, use Reporting calendar.
CFC OB Trans IL	Y	Y	IL version of same GL measure		N	IF(ISBLANK([CFC YTD Trans IL]) , BLANK() ,([CFC YTD Trans IL] - [CFC Trans IL])) // CFC YTD Trans IL - CFC Trans IL = Opening balance in Transaction Currency, use Reporting calendar.
NFC OB Trans IL	Y	Y	IL version of same GL measure		N	IF(ISBLANK([NFC YTD Trans IL]) , BLANK() ,([NFC YTD Trans IL] - [NFC Trans IL])) // NFC YTD Trans IL - NFC Trans IL = Opening balance in Transaction Currency, use Reporting calendar.
ACT PY Trans IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT Trans IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // ACTUAL PREVIOUS YEAR IL in Transaction Currency, use Reporting calendar.
BUD PY Trans IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD Trans IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // BUDGET PREVIOUS YEAR IL in Transaction Currency, use Reporting calendar.
ACT PY R12 Trans IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT R12 Trans IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // ACT PY R12 Trans IL: This measure displays the last available value if presented for multiple periods, eg by quarter then the value in quarter 1 will be the value from March.
BUD PY R12 Trans IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD R12 Trans IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // BUD PY R12 Trans IL: This measure displays the last available value if presented for multiple periods, eg by quarter then the value in quarter 1 will be the value from March.
ACT PY YTD Trans IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT YTD Trans IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // Previous year ACTUAL YTD IL value in Transaction Currency, use Reporting calendar.
BUD PY YTD Trans IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD YTD Trans IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // Previous year BUDGET YTD IL value in Transaction Currency, use Reporting calendar.
ACT R12 Trans IL	Y	Y	IL version of same GL measure		N	VAR First_Period = CALCULATE(MAX('REPORTING PERIOD'[Reporting Year Period]), DATEADD('REPORTING PERIOD'[ID], -11, MONTH)) VAR Last_Period = MAX ( 'REPORTING PERIOD'[Reporting Year Period] ) RETURN CALCULATE ( [ACT Trans IL], FILTER ( ALL ( 'REPORTING PERIOD' ), 'REPORTING PERIOD'[Reporting Year Period] >= First_Period && 'REPORTING PERIOD'[Reporting Year Period] <= Last_Period ) ) // ACT R12 Trans IL: This measure displays the last available value if presented for multiple periods, eg by quarter then the value in quarter 1 will be the value from March.
BUD R12 Trans IL	Y	Y	IL version of same GL measure		N	VAR First_Period = CALCULATE(MAX('REPORTING PERIOD'[Reporting Year Period]), DATEADD('REPORTING PERIOD'[ID], -11, MONTH)) VAR Last_Period = MAX ( 'REPORTING PERIOD'[Reporting Year Period] ) RETURN CALCULATE ( [BUD Trans IL], FILTER ( ALL ( 'REPORTING PERIOD' ), 'REPORTING PERIOD'[Reporting Year Period] >= First_Period && 'REPORTING PERIOD'[Reporting Year Period] <= Last_Period ) ) // BUD R12 Trans IL: This measure displays the last available value if presented for multiple periods, eg by quarter then the value in quarter 1 will be the value from March.
CFC R12 Trans IL	Y	Y	IL version of same GL measure		N	VAR First_Period = CALCULATE(MAX('REPORTING PERIOD'[Reporting Year Period]), DATEADD('REPORTING PERIOD'[ID], -11, MONTH)) VAR Last_Period = MAX ( 'REPORTING PERIOD'[Reporting Year Period] ) RETURN CALCULATE ( [CFC Trans IL], FILTER ( ALL ( 'REPORTING PERIOD' ), 'REPORTING PERIOD'[Reporting Year Period] >= First_Period && 'REPORTING PERIOD'[Reporting Year Period] <= Last_Period ) ) // CFC R12 Trans IL: This measure displays the last available value if presented for multiple periods, eg by quarter then the value in quarter 1 will be the value from March.
NFC R12 Trans IL	Y	Y	IL version of same GL measure		N	VAR First_Period = CALCULATE(MAX('REPORTING PERIOD'[Reporting Year Period]), DATEADD('REPORTING PERIOD'[ID], -11, MONTH)) VAR Last_Period = MAX ( 'REPORTING PERIOD'[Reporting Year Period] ) RETURN CALCULATE ( [NFC Trans IL], FILTER ( ALL ( 'REPORTING PERIOD' ), 'REPORTING PERIOD'[Reporting Year Period] >= First_Period && 'REPORTING PERIOD'[Reporting Year Period] <= Last_Period ) ) // NFC R12 Trans IL: This measure displays the last available value if presented for multiple periods, eg by quarter then the value in quarter 1 will be the value from March.
ACT Credit YTD Trans IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT Credit Trans IL], DATESYTD('REPORTING PERIOD'[ID])) + CALCULATE(SUM('IL ANALYSIS'[ACT_OB_PERIOD_CREDIT_CURR]), DATESYTD('REPORTING PERIOD'[ID])) // ACTUAL CREDIT YTD IL in Transaction Currency, use Reporting calendar.
ACT Debit YTD Trans IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT Debit Trans IL], DATESYTD('REPORTING PERIOD'[ID])) + CALCULATE(SUM('IL ANALYSIS'[ACT_OB_PERIOD_DEBET_CURR]), DATESYTD('REPORTING PERIOD'[ID])) // ACTUAL DEBIT YTD IL in Transaction Currency, use Reporting calendar.
ACT YTD Trans IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT Trans IL], DATESYTD('REPORTING PERIOD'[ID])) + CALCULATE(SUM('IL ANALYSIS'[ACT_OB_PERIOD_CURR]), DATESYTD('REPORTING PERIOD'[ID])) // ACTUAL YTD IL in Transaction Currency, use Reporting calendar.
BUD YTD Trans IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD Trans IL], DATESYTD('REPORTING PERIOD'[ID])) + CALCULATE(SUM('IL ANALYSIS'[BUD_OB_PERIOD_CURR]), DATESYTD('REPORTING PERIOD'[ID])) // BUDGET YTD IL in Transaction Currency, use Reporting calendar.
CFC YTD Trans IL	Y	Y	IL version of same GL measure		N	CALCULATE([CFC Trans IL], DATESYTD('REPORTING PERIOD'[ID])) + CALCULATE(SUM('IL ANALYSIS'[CFC_OB_PERIOD_CURR]), DATESYTD('REPORTING PERIOD'[ID])) // CFC YTD IL in Transaction Currency, use Reporting calendar.
NFC YTD Trans IL	Y	Y	IL version of same GL measure		N	CALCULATE([NFC Trans IL], DATESYTD('REPORTING PERIOD'[ID])) + CALCULATE(SUM('IL ANALYSIS'[NFC_OB_PERIOD_CURR]), DATESYTD('REPORTING PERIOD'[ID])) // NFC YTD IL in Transaction Currency, use Reporting calendar.
ACT Credit Trans IL	Y	Y	IL version of same GL measure		N	SUM('IL ANALYSIS'[ACT_PERIOD_CREDIT_CURR]) // ACTUAL CREDIT IL in Transaction Currency, use Reporting calendar.
ACT Debit Trans IL	Y	Y	IL version of same GL measure		N	SUM('IL ANALYSIS'[ACT_PERIOD_DEBET_CURR]) // ACTUAL DEBIT IL in Transaction Currency, use Reporting calendar.
ACT Trans IL	Y	N	IL version of same GL measure		N	SUM('IL ANALYSIS'[ACT_PERIOD_CURR]) // ACTUAL IL in Transaction Currency, use Reporting calendar.
BUD Trans IL	Y	N	IL version of same GL measure		N	SUM('IL ANALYSIS'[BUD_PERIOD_CURR]) // BUDGET IL in Transaction Currency, use Reporting calendar.
CFC Trans IL	Y	N	IL version of same GL measure		N	SUM('IL ANALYSIS'[CFC_PERIOD_CURR]) // CURRENT FORECAST IL in Transaction Currency, use Reporting calendar.
NFC Trans IL	Y	N	IL version of same GL measure		N	SUM('IL ANALYSIS'[NFC_PERIOD_CURR]) // NEXT FORECAST IL in Transaction Currency, use Reporting calendar.
ACT OB XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), SUMX ( VALUES ( COMPANY[ID] ), [ACT OB IL]*[Conversion rate XR1 IL])) // ACT OB X-rate (Period Based) IL: [ACT OB IL] multiplied with the [rate] at each specific period. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates.
ACTOBPeriodZeroXR1 IL	Y	Y	IL version of same GL measure		N	IF ( HASONEVALUE ( 'CURRENCY CODE X-RATE 1'[Currency Code X-Rate 1] ), VAR RestatedAmount = ADDCOLUMNS ( SUMMARIZE ( 'IL ANALYSIS','REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY'[Currency Code] ), "@GLAmount", CALCULATE ( SUM ( 'IL ANALYSIS'[ACT_OB_PERIOD_DOM] ) ), "@XRATE", CALCULATE ( SELECTEDVALUE ( 'X-RATES 1'[PREV_YEAR_LAST_PERIOD_RATE]) ) ) VAR XAmount = SUMX ( RestatedAmount, [@GLAmount] * [@XRATE] ) RETURN XAmount ) // ACTOBPeriodZeroXR1 IL: Calculates the OB X-rate IL value buy sum all OB-values and multiply with the last rate from previous year. // NOTE: If OB values exists on other periods than the start of the year, then they also is multiplied with the last rate from previous year (not previous period).
BUD OB XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), SUMX ( VALUES ( COMPANY[ID] ), [BUD OB IL]*[Conversion rate XR1 IL])) // BUD OB X-rate (Period Based) IL: [BUD OB IL] multiplied with the [rate] at each specific period. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates.
BUDOBPeriodZeroXR1 IL	Y	Y	IL version of same GL measure		N	IF ( HASONEVALUE ( 'CURRENCY CODE X-RATE 1'[Currency Code X-Rate 1] ), VAR RestatedAmount = ADDCOLUMNS ( SUMMARIZE ( 'IL ANALYSIS','REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY'[Currency Code] ), "@GLAmount", CALCULATE ( SUM ( 'IL ANALYSIS'[BUD_OB_PERIOD_DOM] ) ), "@XRATE", CALCULATE ( SELECTEDVALUE ( 'X-RATES 1'[PREV_YEAR_LAST_PERIOD_RATE]) ) ) VAR XAmount = SUMX ( RestatedAmount, [@GLAmount] * [@XRATE] ) RETURN XAmount ) // BUDOBPeriodZeroXR1 IL: Calculates the OB X-rate IL value buy sum all OB-values and multiply with the last rate from previous year. // NOTE: If OB values exists on other periods than the start of the year, then they also is multiplied with the last rate from previous year (not previous period).
CFC OB XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), SUMX ( VALUES ( COMPANY[ID] ), [CFC OB IL]*[Conversion rate XR1 IL])) // CFC OB X-rate (Period Based) IL: [CFC OB IL] multiplied with the [rate] at each specific period. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates.
CFCOBPeriodZeroXR1 IL	Y	Y	IL version of same GL measure		N	IF ( HASONEVALUE ( 'CURRENCY CODE X-RATE 1'[Currency Code X-Rate 1] ), VAR RestatedAmount = ADDCOLUMNS ( SUMMARIZE ( 'IL ANALYSIS','REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY'[Currency Code] ), "@GLAmount", CALCULATE ( SUM ( 'IL ANALYSIS'[CFC_OB_PERIOD_DOM] ) ), "@XRATE", CALCULATE ( SELECTEDVALUE ( 'X-RATES 1'[PREV_YEAR_LAST_PERIOD_RATE]) ) ) VAR XAmount = SUMX ( RestatedAmount, [@GLAmount] * [@XRATE] ) RETURN XAmount ) // CFCOBPeriodZeroXR1 IL: Calculates the OB X-rate IL value buy sum all OB-values and multiply with the last rate from previous year. // NOTE: If OB values exists on other periods than the start of the year, then they also is multiplied with the last rate from previous year (not previous period).
NFC OB XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), SUMX ( VALUES ( COMPANY[ID] ), [NFC OB IL]*[Conversion rate XR1 IL])) // NFC OB X-rate (Period Based) IL: [NFC OB IL] multiplied with the [rate] at each specific period. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates.
NFCOBPeriodZeroXR1 IL	Y	Y	IL version of same GL measure		N	IF ( HASONEVALUE ( 'CURRENCY CODE X-RATE 1'[Currency Code X-Rate 1] ), VAR RestatedAmount = ADDCOLUMNS ( SUMMARIZE ( 'IL ANALYSIS','REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY'[Currency Code] ), "@GLAmount", CALCULATE ( SUM ( 'IL ANALYSIS'[NFC_OB_PERIOD_DOM] ) ), "@XRATE", CALCULATE ( SELECTEDVALUE ( 'X-RATES 1'[PREV_YEAR_LAST_PERIOD_RATE]) ) ) VAR XAmount = SUMX ( RestatedAmount, [@GLAmount] * [@XRATE] ) RETURN XAmount ) // NFCOBPeriodZeroXR1 IL: Calculates the OB X-rate IL value buy sum all OB-values and multiply with the last rate from previous year. // NOTE: If OB values exists on other periods than the start of the year, then they also is multiplied with the last rate from previous year (not previous period).
ACT PY XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // ACT PY X-rate (Period Based) IL: ACT X-rate IL from the same reporting period previous year.
BUD PY XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // BUD PY X-rate (Period Based) IL: BUD X-rate IL from the same reporting period previous year.
ACT PY R12 XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT R12 XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // ACT PY R12 X-rate (Period Based) IL: R12 X-rate IL from the same period previous year. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
BUD PY R12 XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD R12 XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // BUD PY R12 X-rate (Period Based) IL: R12 X-rate IL from the same period previous year. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
ACT PY YTD XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE ( [ACT YTD XR1 (Period Based) IL], DATEADD ( 'REPORTING PERIOD'[ID], -12, MONTH ) ) // ACT PY YTD X-rate (Period Based) IL: ACT YTD Xrate IL from the same reporting period previous year.
ACT R12 XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), [ACT XR1 (Period Based) IL] + CALCULATE([ACT XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -1, MONTH)) + CALCULATE([ACT XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -2, MONTH)) + CALCULATE([ACT XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -3, MONTH)) + CALCULATE([ACT XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -4, MONTH)) + CALCULATE([ACT XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -5, MONTH)) + CALCULATE([ACT XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -6, MONTH)) + CALCULATE([ACT XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -7, MONTH)) + CALCULATE([ACT XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -8, MONTH)) + CALCULATE([ACT XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -9, MONTH)) + CALCULATE([ACT XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -10, MONTH)) + CALCULATE([ACT XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -11, MONTH)) ) // ACT R12 X-rate (Period Based) IL: The sum of [ACT XR1 (Period Based) IL] for the current month and [ACT XR1 (Period Based) IL] values from each of the previous 11 months. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
BUD R12 XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), [BUD XR1 (Period Based) IL] + CALCULATE([BUD XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -1, MONTH)) + CALCULATE([BUD XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -2, MONTH)) + CALCULATE([BUD XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -3, MONTH)) + CALCULATE([BUD XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -4, MONTH)) + CALCULATE([BUD XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -5, MONTH)) + CALCULATE([BUD XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -6, MONTH)) + CALCULATE([BUD XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -7, MONTH)) + CALCULATE([BUD XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -8, MONTH)) + CALCULATE([BUD XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -9, MONTH)) + CALCULATE([BUD XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -10, MONTH)) + CALCULATE([BUD XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -11, MONTH)) ) // BUD R12 X-rate (Period Based) IL: The sum of [BUD XR1 (Period Based) IL] for the current month and [BUD XR1 (Period Based) IL] values from each of the previous 11 months. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
CFC R12 XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), [CFC XR1 (Period Based) IL] + CALCULATE([CFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -1, MONTH)) + CALCULATE([CFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -2, MONTH)) + CALCULATE([CFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -3, MONTH)) + CALCULATE([CFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -4, MONTH)) + CALCULATE([CFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -5, MONTH)) + CALCULATE([CFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -6, MONTH)) + CALCULATE([CFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -7, MONTH)) + CALCULATE([CFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -8, MONTH)) + CALCULATE([CFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -9, MONTH)) + CALCULATE([CFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -10, MONTH)) + CALCULATE([CFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -11, MONTH)) ) // CFC R12 X-rate (Period Based) IL: The sum of [CFC XR1 (Period Based) IL] for the current month and [CFC XR1 (Period Based) IL] values from each of the previous 11 months. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
NFC R12 XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), [NFC XR1 (Period Based) IL] + CALCULATE([NFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -1, MONTH)) + CALCULATE([NFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -2, MONTH)) + CALCULATE([NFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -3, MONTH)) + CALCULATE([NFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -4, MONTH)) + CALCULATE([NFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -5, MONTH)) + CALCULATE([NFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -6, MONTH)) + CALCULATE([NFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -7, MONTH)) + CALCULATE([NFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -8, MONTH)) + CALCULATE([NFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -9, MONTH)) + CALCULATE([NFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -10, MONTH)) + CALCULATE([NFC XR1 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -11, MONTH)) ) // NFC R12 X-rate (Period Based) IL: The sum of [NFC XR1 (Period Based) IL] for the current month and [NFC XR1 (Period Based) IL] values from each of the previous 11 months. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
ACT YTD XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE ( [ACTOBPeriodZeroXR1 IL], DATESYTD ( 'REPORTING PERIOD'[ID] ) ) + CALCULATE ( [ACT XR1 (Period Based) IL], DATESYTD ( 'REPORTING PERIOD'[ID] ) ) // ACT YTD X-rate (Period Based) IL: This YTD value includes the sum of both OB and ACT values.
BUD YTD XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE ( [BUDOBPeriodZeroXR1 IL], DATESYTD ( 'REPORTING PERIOD'[ID] ) ) + CALCULATE ( [BUD XR1 (Period Based) IL], DATESYTD ( 'REPORTING PERIOD'[ID] ) ) // BUD YTD X-rate (Period Based) IL: This YTD value includes the sum of both OB and BUD values.
CFC YTD XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE ( [CFCOBPeriodZeroXR1 IL], DATESYTD ( 'REPORTING PERIOD'[ID] ) ) + CALCULATE ( [CFC XR1 (Period Based) IL], DATESYTD ( 'REPORTING PERIOD'[ID] ) ) // CFC YTD X-rate (Period Based) IL: This YTD value includes the sum of both OB and CFC values.
NFC YTD XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE ( [NFCOBPeriodZeroXR1 IL], DATESYTD ( 'REPORTING PERIOD'[ID] ) ) + CALCULATE ( [NFC XR1 (Period Based) IL], DATESYTD ( 'REPORTING PERIOD'[ID] ) ) // NFC YTD X-rate (Period Based) IL: This YTD value includes the sum of both OB and NFC values.
ACT Credit XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF(HASONEVALUE('CURRENCY CODE X-RATE 1'[Currency Code X-Rate 1]), VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('IL ANALYSIS' ,'REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY'[Currency Code]) ,"@GLAmount",CALCULATE([ACT Credit IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES 1'[CURRENCYRATE])) ) VAR XAmount = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN XAmount ) // ACTUAL CREDIT IL in X-rate 1 Currency, use Reporting calendar.
ACT Debit XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF(HASONEVALUE('CURRENCY CODE X-RATE 1'[Currency Code X-Rate 1]), VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('IL ANALYSIS' ,'REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY'[Currency Code]) ,"@GLAmount",CALCULATE([ACT Debit IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES 1'[CURRENCYRATE])) ) VAR XAmount = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN XAmount ) // ACTUAL DEBIT IL in X-rate 1 Currency, use Reporting calendar.
ACT XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF(HASONEVALUE('CURRENCY CODE X-RATE 1'[Currency Code X-Rate 1]), VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('IL ANALYSIS' ,'REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY'[Currency Code]) ,"@GLAmount",CALCULATE([ACT IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES 1'[CURRENCYRATE])) ) VAR XAmount = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN XAmount ) // ACTUAL IL in X-rate 1 Currency, use Reporting calendar.
BUD XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF(HASONEVALUE('CURRENCY CODE X-RATE 1'[Currency Code X-Rate 1]), VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('IL ANALYSIS' ,'REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY'[Currency Code]) ,"@GLAmount",CALCULATE([BUD IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES 1'[CURRENCYRATE])) ) VAR XAmount = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN XAmount ) // BUDGET IL in X-rate 1 Currency, use Reporting calendar.
CFC XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF(HASONEVALUE('CURRENCY CODE X-RATE 1'[Currency Code X-Rate 1]), VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('IL ANALYSIS' ,'REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY'[Currency Code]) ,"@GLAmount",CALCULATE([CFC IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES 1'[CURRENCYRATE])) ) VAR XAmount = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN XAmount ) // CURRENT FORECAST IL in X-rate 1 Currency, use Reporting calendar.
NFC XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF(HASONEVALUE('CURRENCY CODE X-RATE 1'[Currency Code X-Rate 1]), VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('IL ANALYSIS' ,'REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY'[Currency Code]) ,"@GLAmount",CALCULATE([NFC IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES 1'[CURRENCYRATE])) ) VAR XAmount = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN XAmount ) // NEXT FORECAST IL in X-rate 1 Currency, use Reporting calendar.
ACT OB XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	VAR CurrPeriod = MAX('REPORTING PERIOD'[Reporting Period]) VAR MonthsInPeriod = MAX('REPORTING PERIOD'[Months In Period]) RETURN IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK() , IF ( CurrPeriod = 1, CALCULATE([ACT OB XR1 (Period Based) IL]), CALCULATE([ACT YTD XR1 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID], -MonthsInPeriod, MONTH) ) )) // ACT OB X-rate (YTD Based) IL: The YTD value from previous period, part from period 1 in which calculation is OB*rate. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
BUD OB XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	VAR CurrPeriod = MAX('REPORTING PERIOD'[Reporting Period]) VAR MonthsInPeriod = MAX('REPORTING PERIOD'[Months In Period]) RETURN IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK() , IF ( CurrPeriod = 1, CALCULATE([BUD OB XR1 (Period Based) IL]), CALCULATE([BUD YTD XR1 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID], -MonthsInPeriod, MONTH) ) )) // BUD OB X-rate (YTD Based) IL: The YTD value from previous period, part from period 1 in which calculation is OB*rate. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
CFC OB XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	VAR CurrPeriod = MAX('REPORTING PERIOD'[Reporting Period]) VAR MonthsInPeriod = MAX('REPORTING PERIOD'[Months In Period]) RETURN IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK() , IF ( CurrPeriod = 1, CALCULATE([CFC OB XR1 (Period Based) IL]), CALCULATE([CFC YTD XR1 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID], -MonthsInPeriod, MONTH) ) )) // CFC OB X-rate (YTD Based) IL: The YTD value from previous period, part from period 1 in which calculation is OB*rate. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
NFC OB XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	VAR CurrPeriod = MAX('REPORTING PERIOD'[Reporting Period]) VAR MonthsInPeriod = MAX('REPORTING PERIOD'[Months In Period]) RETURN IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK() , IF ( CurrPeriod = 1, CALCULATE([NFC OB XR1 (Period Based) IL]), CALCULATE([NFC YTD XR1 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID], -MonthsInPeriod, MONTH) ) )) // NFC OB X-rate (YTD Based) IL: The YTD value from previous period, part from period 1 in which calculation is OB*rate. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
ACT PY XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT XR1 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // ACT PY X-rate (YTD Based) IL: The value from the same period last year.
BUD PY XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD XR1 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // BUD PY X-rate (YTD Based) IL: The value from the same period last year.
ACT PY R12 XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT R12 XR1 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // ACT PY R12 X-rate (YTD Based) IL: R12 from the same period previous year.
BUD PY R12 XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD R12 XR1 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // BUD PY R12 X-rate (YTD Based) IL: R12 from the same period previous year.
ACT PY YTD XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT YTD XR1 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // ACT PY YTD X-rate (YTD Based) IL: The YTD value for the same period last year.
BUD PY YTD XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD YTD XR1 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // BUD PY YTD X-rate (YTD Based) IL: The YTD value for the same period last year.
ACT R12 XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	SUMX ( VALUES ( COMPANY[ID] ), [ACT R12 IL]*[Conversion rate XR1 IL]) // ACT R12 X-rate (YTD Based) IL: The R12-value multiplied with the rate at the that specific Reporting period. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates.
BUD R12 XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	SUMX ( VALUES ( COMPANY[ID] ), [BUD R12 IL]*[Conversion rate XR1 IL]) // BUD R12 X-rate (YTD Based) IL: The R12-value multiplied with the rate at the that specific Reporting period. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates.
CFC R12 XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	SUMX ( VALUES ( COMPANY[ID] ), [CFC R12 IL]*[Conversion rate XR1 IL]) // CFC R12 X-rate (YTD Based) IL: The R12-value multiplied with the rate at the that specific Reporting period. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates.
NFC R12 XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	SUMX ( VALUES ( COMPANY[ID] ), [NFC R12 IL]*[Conversion rate XR1 IL]) // NFC R12 X-rate (YTD Based) IL: The R12-value multiplied with the rate at the that specific Reporting period. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates.
ACT YTD XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	SUMX ( VALUES ( COMPANY[ID] ), LASTNONBLANKVALUE('REPORTING PERIOD'[ID],[ACT YTD IL]*[Conversion rate XR1 IL])) // ACT YTD X-rate (YTD Based) IL: The YTD value multiplied with the current rate. // LASTNONBLANKVALUE to handle TOTALS at Quarter and Year level to be the value from the last period within the quarter or year. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates. // If ever to update this code: Heads up on verifing the results on Quarter and Year level in the multi-company scenario.
BUD YTD XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	SUMX ( VALUES ( COMPANY[ID] ), LASTNONBLANKVALUE('REPORTING PERIOD'[ID],[BUD YTD IL]*[Conversion rate XR1 IL])) // BUD YTD X-rate (YTD Based) IL: The YTD value multiplied with the current rate. // LASTNONBLANKVALUE to handle TOTALS at Quarter and Year level to be the value from the last period within the quarter or year. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates. // If ever to update this code: Heads up on verifing the results on Quarter and Year level in the multi-company scenario.
CFC YTD XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	SUMX ( VALUES ( COMPANY[ID] ), LASTNONBLANKVALUE('REPORTING PERIOD'[ID],[CFC YTD IL]*[Conversion rate XR1 IL])) // CFC YTD X-rate (YTD Based) IL: The YTD value multiplied with the current rate. // LASTNONBLANKVALUE to handle TOTALS at Quarter and Year level to be the value from the last period within the quarter or year. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates. // If ever to update this code: Heads up on verifing the results on Quarter and Year level in the multi-company scenario.
NFC YTD XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	SUMX ( VALUES ( COMPANY[ID] ), LASTNONBLANKVALUE('REPORTING PERIOD'[ID],[NFC YTD IL]*[Conversion rate XR1 IL])) // NFC YTD X-rate (YTD Based) IL: The YTD value multiplied with the current rate. // LASTNONBLANKVALUE to handle TOTALS at Quarter and Year level to be the value from the last period within the quarter or year. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates. // If ever to update this code: Heads up on verifing the results on Quarter and Year level in the multi-company scenario.
ACT XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	VAR CurrPeriod = MAX('REPORTING PERIOD'[Reporting Period]) RETURN IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), IF( CurrPeriod = 1, SUMX (VALUES ( COMPANY[ID] ), ([ACT IL][Conversion rate XR1 IL]) ), SUMX (VALUES ( COMPANY[ID] ), ([ACT YTD IL][Conversion rate XR1 IL]) - ([ACT OB IL][Conversion rate PP XR1 IL])) ) ) // ACT X-rate (YTD Based) IL: (ACT YTD X-rate IL) minus (OB IL rate in previous period). Note that OB is the same as the YTD-value in the previous period. // In case no addition of ACT from previous period, this is just the effect of the same YTD value being multiplied with rate in previous period compared with the rate in this period. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level. HasOnValuePeriod is to ensure Blank values.
BUD XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	VAR CurrPeriod = MAX('REPORTING PERIOD'[Reporting Period]) RETURN IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), IF( CurrPeriod = 1, SUMX (VALUES ( COMPANY[ID] ), ([BUD IL][Conversion rate XR1 IL]) ), SUMX (VALUES ( COMPANY[ID] ), ([BUD YTD IL][Conversion rate XR1 IL]) - ([BUD OB IL][Conversion rate PP XR1 IL])) ) ) // BUD X-rate (YTD Based) IL: (BUD YTD X-rate IL) minus (OB IL rate in previous period). Note that OB is the same as the YTD-value in the previous period. // In case no addition of BUD from previous period, this is just the effect of the same YTD value being multiplied with rate in previous period compared with the rate in this period. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level. HasOnValuePeriod is to ensure Blank values.
CFC XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	VAR CurrPeriod = MAX('REPORTING PERIOD'[Reporting Period]) RETURN IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), IF( CurrPeriod = 1, SUMX (VALUES ( COMPANY[ID] ), ([CFC IL][Conversion rate XR1 IL]) ), SUMX (VALUES ( COMPANY[ID] ), ([CFC YTD IL][Conversion rate XR1 IL]) - ([CFC OB IL][Conversion rate PP XR1 IL])) ) ) // CFC X-rate (YTD Based) IL: (CFC YTD X-rate IL) minus (OB IL rate in previous period). Note that OB is the same as the YTD-value in the previous period. // In case no addition of CFC from previous period, this is just the effect of the same YTD value being multiplied with rate in previous period compared with the rate in this period. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level. HasOnValuePeriod is to ensure Blank values.
NFC XR1 (YTD Based) IL	Y	Y	IL version of same GL measure		N	VAR CurrPeriod = MAX('REPORTING PERIOD'[Reporting Period]) RETURN IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), IF( CurrPeriod = 1, SUMX (VALUES ( COMPANY[ID] ), ([NFC IL][Conversion rate XR1 IL]) ), SUMX (VALUES ( COMPANY[ID] ), ([NFC YTD IL][Conversion rate XR1 IL]) - ([NFC OB IL][Conversion rate PP XR1 IL])) ) ) // NFC X-rate (YTD Based) IL: (NFC YTD X-rate IL) minus (OB IL rate in previous period). Note that OB is the same as the YTD-value in the previous period. // In case no addition of NFC from previous period, this is just the effect of the same YTD value being multiplied with rate in previous period compared with the rate in this period. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level. HasOnValuePeriod is to ensure Blank values.
ACT OB XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), SUMX ( VALUES ( COMPANY[ID] ), [ACT OB IL]*[Conversion rate XR2 IL])) // ACT OB X-rate (Period Based) IL: [ACT OB] multiplied with the [rate] at each specific period. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates.
ACTOBPeriodZeroXR2 IL	Y	Y	IL version of same GL measure		N	IF ( HASONEVALUE ( 'CURRENCY CODE X-RATE 2'[Currency Code X-Rate 2] ), VAR RestatedAmount = ADDCOLUMNS ( SUMMARIZE ( 'IL ANALYSIS','REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY 2'[Currency Code] ), "@GLAmount", CALCULATE ( SUM ( 'IL ANALYSIS'[ACT_OB_PERIOD_DOM] ) ), "@XRATE", CALCULATE ( SELECTEDVALUE ( 'X-RATES 2'[PREV_YEAR_LAST_PERIOD_RATE]) ) ) VAR XAmount = SUMX ( RestatedAmount, [@GLAmount] * [@XRATE] ) RETURN XAmount ) // ACTOBPeriodZeroXR2 IL: Calculates the OB X-rate value buy sum all OB-values and multiply with the last rate from previous year. // NOTE: If OB values exists on other periods than the start of the year, then they also is multiplied with the last rate from previous year (not previous period).
BUD OB XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), SUMX ( VALUES ( COMPANY[ID] ), [BUD OB IL]*[Conversion rate XR2 IL])) // BUD OB X-rate (Period Based) IL: [BUD OB] multiplied with the [rate] at each specific period. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates.
BUDOBPeriodZeroXR2 IL	Y	Y	IL version of same GL measure		N	IF ( HASONEVALUE ( 'CURRENCY CODE X-RATE 2'[Currency Code X-Rate 2] ), VAR RestatedAmount = ADDCOLUMNS ( SUMMARIZE ( 'IL ANALYSIS','REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY 2'[Currency Code] ), "@GLAmount", CALCULATE ( SUM ( 'IL ANALYSIS'[BUD_OB_PERIOD_DOM] ) ), "@XRATE", CALCULATE ( SELECTEDVALUE ( 'X-RATES 2'[PREV_YEAR_LAST_PERIOD_RATE]) ) ) VAR XAmount = SUMX ( RestatedAmount, [@GLAmount] * [@XRATE] ) RETURN XAmount ) // BUDOBPeriodZeroXR2 IL: Calculates the OB X-rate value buy sum all OB-values and multiply with the last rate from previous year. // NOTE: If OB values exists on other periods than the start of the year, then they also is multiplied with the last rate from previous year (not previous period).
CFC OB XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), SUMX ( VALUES ( COMPANY[ID] ), [CFC OB IL]*[Conversion rate XR2 IL])) // CFC OB X-rate (Period Based) IL: [CFC OB] multiplied with the [rate] at each specific period. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates.
CFCOBPeriodZeroXR2 IL	Y	Y	IL version of same GL measure		N	IF ( HASONEVALUE ( 'CURRENCY CODE X-RATE 2'[Currency Code X-Rate 2] ), VAR RestatedAmount = ADDCOLUMNS ( SUMMARIZE ( 'IL ANALYSIS','REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY 2'[Currency Code] ), "@GLAmount", CALCULATE ( SUM ( 'IL ANALYSIS'[CFC_OB_PERIOD_DOM] ) ), "@XRATE", CALCULATE ( SELECTEDVALUE ( 'X-RATES 2'[PREV_YEAR_LAST_PERIOD_RATE]) ) ) VAR XAmount = SUMX ( RestatedAmount, [@GLAmount] * [@XRATE] ) RETURN XAmount ) // CFCOBPeriodZeroXR2 IL: Calculates the OB X-rate value buy sum all OB-values and multiply with the last rate from previous year. // NOTE: If OB values exists on other periods than the start of the year, then they also is multiplied with the last rate from previous year (not previous period).
NFC OB XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), SUMX ( VALUES ( COMPANY[ID] ), [NFC OB IL]*[Conversion rate XR2 IL])) // NFC OB X-rate (Period Based) IL: [NFC OB] multiplied with the [rate] at each specific period. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates.
NFCOBPeriodZeroXR2 IL	Y	Y	IL version of same GL measure		N	IF ( HASONEVALUE ( 'CURRENCY CODE X-RATE 2'[Currency Code X-Rate 2] ), VAR RestatedAmount = ADDCOLUMNS ( SUMMARIZE ( 'IL ANALYSIS','REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY 2'[Currency Code] ), "@GLAmount", CALCULATE ( SUM ( 'IL ANALYSIS'[NFC_OB_PERIOD_DOM] ) ), "@XRATE", CALCULATE ( SELECTEDVALUE ( 'X-RATES 2'[PREV_YEAR_LAST_PERIOD_RATE]) ) ) VAR XAmount = SUMX ( RestatedAmount, [@GLAmount] * [@XRATE] ) RETURN XAmount ) // NFCOBPeriodZeroXR2 IL: Calculates the OB X-rate value buy sum all OB-values and multiply with the last rate from previous year. // NOTE: If OB values exists on other periods than the start of the year, then they also is multiplied with the last rate from previous year (not previous period).
ACT PY XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // ACT PY X-rate (Period Based) IL: ACT X-rate from the same reporting period previous year.
BUD PY XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // BUD PY X-rate (Period Based) IL: BUD X-rate from the same reporting period previous year.
ACT PY R12 XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT R12 XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // ACT PY R12 X-rate (Period Based) IL: R12 X-rate from the same period previous year. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
BUD PY R12 XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD R12 XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // BUD PY R12 X-rate (Period Based) IL: R12 X-rate from the same period previous year. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
ACT PY YTD XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE ( [ACT YTD XR2 (Period Based) IL], DATEADD ( 'REPORTING PERIOD'[ID], -12, MONTH ) ) // ACT PY YTD X-rate (Period Based) IL: ACT YTD Xrate from the same reporting period previous year.
ACT R12 XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), [ACT XR2 (Period Based) IL] + CALCULATE([ACT XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -1, MONTH)) + CALCULATE([ACT XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -2, MONTH)) + CALCULATE([ACT XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -3, MONTH)) + CALCULATE([ACT XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -4, MONTH)) + CALCULATE([ACT XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -5, MONTH)) + CALCULATE([ACT XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -6, MONTH)) + CALCULATE([ACT XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -7, MONTH)) + CALCULATE([ACT XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -8, MONTH)) + CALCULATE([ACT XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -9, MONTH)) + CALCULATE([ACT XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -10, MONTH)) + CALCULATE([ACT XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -11, MONTH)) ) // ACT R12 X-rate (Period Based) IL: The sum of [ACT XR2 (Period Based) IL] for the current month and [ACT XR2 (Period Based) IL] values from each of the previous 11 months. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
BUD R12 XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), [BUD XR2 (Period Based) IL] + CALCULATE([BUD XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -1, MONTH)) + CALCULATE([BUD XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -2, MONTH)) + CALCULATE([BUD XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -3, MONTH)) + CALCULATE([BUD XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -4, MONTH)) + CALCULATE([BUD XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -5, MONTH)) + CALCULATE([BUD XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -6, MONTH)) + CALCULATE([BUD XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -7, MONTH)) + CALCULATE([BUD XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -8, MONTH)) + CALCULATE([BUD XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -9, MONTH)) + CALCULATE([BUD XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -10, MONTH)) + CALCULATE([BUD XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -11, MONTH)) ) // BUD R12 X-rate (Period Based) IL: The sum of [BUD XR2 (Period Based) IL] for the current month and [BUD XR2 (Period Based) IL] values from each of the previous 11 months. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
CFC R12 XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), [CFC XR2 (Period Based) IL] + CALCULATE([CFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -1, MONTH)) + CALCULATE([CFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -2, MONTH)) + CALCULATE([CFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -3, MONTH)) + CALCULATE([CFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -4, MONTH)) + CALCULATE([CFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -5, MONTH)) + CALCULATE([CFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -6, MONTH)) + CALCULATE([CFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -7, MONTH)) + CALCULATE([CFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -8, MONTH)) + CALCULATE([CFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -9, MONTH)) + CALCULATE([CFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -10, MONTH)) + CALCULATE([CFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -11, MONTH)) ) // CFC R12 X-rate (Period Based) IL: The sum of [CFC XR2 (Period Based) IL] for the current month and [CFC XR2 (Period Based) IL] values from each of the previous 11 months. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
NFC R12 XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), [NFC XR2 (Period Based) IL] + CALCULATE([NFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -1, MONTH)) + CALCULATE([NFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -2, MONTH)) + CALCULATE([NFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -3, MONTH)) + CALCULATE([NFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -4, MONTH)) + CALCULATE([NFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -5, MONTH)) + CALCULATE([NFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -6, MONTH)) + CALCULATE([NFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -7, MONTH)) + CALCULATE([NFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -8, MONTH)) + CALCULATE([NFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -9, MONTH)) + CALCULATE([NFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -10, MONTH)) + CALCULATE([NFC XR2 (Period Based) IL], DATEADD('REPORTING PERIOD'[ID], -11, MONTH)) ) // NFC R12 X-rate (Period Based) IL: The sum of [NFC XR2 (Period Based) IL] for the current month and [NFC XR2 (Period Based) IL] values from each of the previous 11 months. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
ACT YTD XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE ( [ACTOBPeriodZeroXR2 IL], DATESYTD ( 'REPORTING PERIOD'[ID] ) ) + CALCULATE ( [ACT XR2 (Period Based) IL], DATESYTD ( 'REPORTING PERIOD'[ID] ) ) // ACT YTD X-rate (Period Based) IL: This YTD value includes the sum of both OB and ACT values.
BUD YTD XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE ( [BUDOBPeriodZeroXR2 IL], DATESYTD ( 'REPORTING PERIOD'[ID] ) ) + CALCULATE ( [BUD XR2 (Period Based) IL], DATESYTD ( 'REPORTING PERIOD'[ID] ) ) // BUD YTD X-rate (Period Based) IL: This YTD value includes the sum of both OB and BUD values.
CFC YTD XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE ( [CFCOBPeriodZeroXR2 IL], DATESYTD ( 'REPORTING PERIOD'[ID] ) ) + CALCULATE ( [CFC XR2 (Period Based) IL], DATESYTD ( 'REPORTING PERIOD'[ID] ) ) // CFC YTD X-rate (Period Based) IL: This YTD value includes the sum of both OB and CFC values.
NFC YTD XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE ( [NFCOBPeriodZeroXR2 IL], DATESYTD ( 'REPORTING PERIOD'[ID] ) ) + CALCULATE ( [NFC XR2 (Period Based) IL], DATESYTD ( 'REPORTING PERIOD'[ID] ) ) // NFC YTD X-rate (Period Based) IL: This YTD value includes the sum of both OB and NFC values.
ACT Credit XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF(HASONEVALUE('CURRENCY CODE X-RATE 2'[Currency Code X-Rate 2]), VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('IL ANALYSIS' ,'REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY 2'[Currency Code]) ,"@GLAmount",CALCULATE([ACT Credit IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES 2'[CURRENCYRATE])) ) VAR XAmount = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN XAmount ) // ACTUAL CREDIT IL in X-rate 2 Currency, use Reporting calendar.
ACT Debit XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF(HASONEVALUE('CURRENCY CODE X-RATE 2'[Currency Code X-Rate 2]), VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('IL ANALYSIS' ,'REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY 2'[Currency Code]) ,"@GLAmount",CALCULATE([ACT Debit IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES 2'[CURRENCYRATE])) ) VAR XAmount = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN XAmount ) // ACTUAL DEBIT IL in X-rate 2 Currency, use Reporting calendar.
ACT XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF(HASONEVALUE('CURRENCY CODE X-RATE 2'[Currency Code X-Rate 2]), VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('IL ANALYSIS' ,'REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY 2'[Currency Code]) ,"@GLAmount",CALCULATE([ACT IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES 2'[CURRENCYRATE])) ) VAR XAmount = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN XAmount ) // ACTUAL IL in X-rate 2 Currency, use Reporting calendar.
BUD XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF(HASONEVALUE('CURRENCY CODE X-RATE 2'[Currency Code X-Rate 2]), VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('IL ANALYSIS' ,'REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY 2'[Currency Code]) ,"@GLAmount",CALCULATE([BUD IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES 2'[CURRENCYRATE])) ) VAR XAmount = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN XAmount ) // BUDGET IL in X-rate 2 Currency, use Reporting calendar.
CFC XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF(HASONEVALUE('CURRENCY CODE X-RATE 2'[Currency Code X-Rate 2]), VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('IL ANALYSIS' ,'REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY 2'[Currency Code]) ,"@GLAmount",CALCULATE([CFC IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES 2'[CURRENCYRATE])) ) VAR XAmount = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN XAmount ) // CURRENT FORECAST IL in X-rate 2 Currency, use Reporting calendar.
NFC XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	IF(HASONEVALUE('CURRENCY CODE X-RATE 2'[Currency Code X-Rate 2]), VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('IL ANALYSIS' ,'REPORTING PERIOD'[ID],'REPORTING FROM CURRENCY 2'[Currency Code]) ,"@GLAmount",CALCULATE([NFC IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES 2'[CURRENCYRATE])) ) VAR XAmount = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN XAmount ) // NEXT FORECAST IL in X-rate 2 Currency, use Reporting calendar.
ACT OB XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	VAR CurrPeriod = MAX('REPORTING PERIOD'[Reporting Period]) VAR MonthsInPeriod = MAX('REPORTING PERIOD'[Months In Period]) RETURN IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK() , IF ( CurrPeriod = 1, CALCULATE([ACT OB XR2 (Period Based) IL]), CALCULATE([ACT YTD XR2 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID], -MonthsInPeriod, MONTH) ) )) // ACT OB X-rate (YTD Based) IL: The YTD value from previous period, part from period 1 in which calculation is OB*rate. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
BUD OB XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	VAR CurrPeriod = MAX('REPORTING PERIOD'[Reporting Period]) VAR MonthsInPeriod = MAX('REPORTING PERIOD'[Months In Period]) RETURN IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK() , IF ( CurrPeriod = 1, CALCULATE([BUD OB XR2 (Period Based) IL]), CALCULATE([BUD YTD XR2 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID], -MonthsInPeriod, MONTH) ) )) // BUD OB X-rate (YTD Based) IL: The YTD value from previous period, part from period 1 in which calculation is OB*rate. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
CFC OB XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	VAR CurrPeriod = MAX('REPORTING PERIOD'[Reporting Period]) VAR MonthsInPeriod = MAX('REPORTING PERIOD'[Months In Period]) RETURN IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK() , IF ( CurrPeriod = 1, CALCULATE([CFC OB XR2 (Period Based) IL]), CALCULATE([CFC YTD XR2 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID], -MonthsInPeriod, MONTH) ) )) // CFC OB X-rate (YTD Based) IL: The YTD value from previous period, part from period 1 in which calculation is OB*rate. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
NFC OB XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	VAR CurrPeriod = MAX('REPORTING PERIOD'[Reporting Period]) VAR MonthsInPeriod = MAX('REPORTING PERIOD'[Months In Period]) RETURN IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK() , IF ( CurrPeriod = 1, CALCULATE([NFC OB XR2 (Period Based) IL]), CALCULATE([NFC YTD XR2 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID], -MonthsInPeriod, MONTH) ) )) // NFC OB X-rate (YTD Based) IL: The YTD value from previous period, part from period 1 in which calculation is OB*rate. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level.
ACT PY XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT XR2 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // ACT PY X-rate (YTD Based) IL: The value from the same period last year.
BUD PY XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD XR2 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // BUD PY X-rate (YTD Based) IL: The value from the same period last year.
ACT PY R12 XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT R12 XR2 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // ACT PY R12 X-rate (YTD Based) IL: R12 from the same period previous year.
BUD PY R12 XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD R12 XR2 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // BUD PY R12 X-rate (YTD Based) IL: R12 from the same period previous year.
ACT PY YTD XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([ACT YTD XR2 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // ACT PY YTD X-rate (YTD Based) IL: The YTD value for the same period last year.
BUD PY YTD XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE([BUD YTD XR2 (YTD Based) IL], DATEADD('REPORTING PERIOD'[ID],-12,month)) // BUD PY YTD X-rate (YTD Based) IL: The YTD value for the same period last year.
ACT R12 XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	SUMX ( VALUES ( COMPANY[ID] ), LASTNONBLANKVALUE('REPORTING PERIOD'[ID],[ACT R12 IL]*[Conversion rate XR2 IL])) // ACT R12 X-rate (YTD Based) IL: The R12-value multiplied with the rate at the that specific Reporting period. // The calculation is done for one company at the time due to difference in base_currency. // LASTBLANKVALUE function is used to present the value from the last available Reporting period when presenting on Quarter, Half year or Year level.
BUD R12 XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	SUMX ( VALUES ( COMPANY[ID] ), LASTNONBLANKVALUE('REPORTING PERIOD'[ID],[BUD R12 IL]*[Conversion rate XR2 IL])) // BUD R12 X-rate (YTD Based) IL: The R12-value multiplied with the rate at the that specific Reporting period. // The calculation is done for one company at the time due to difference in base_currency. // LASTBLANKVALUE function is used to present the value from the last available Reporting period when presenting on Quarter, Half year or Year level.
CFC R12 XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	SUMX ( VALUES ( COMPANY[ID] ), LASTNONBLANKVALUE('REPORTING PERIOD'[ID],[CFC R12 IL]*[Conversion rate XR2 IL])) // CFC R12 X-rate (YTD Based) IL: The R12-value multiplied with the rate at the that specific Reporting period. // The calculation is done for one company at the tme due to difference in base_currency. // LASTBLANKVALUE function is used to present the value from the last available Reporting period when presenting on Quarter, Half year or Year level.
NFC R12 XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	SUMX ( VALUES ( COMPANY[ID] ), LASTNONBLANKVALUE('REPORTING PERIOD'[ID],[NFC R12 IL]*[Conversion rate XR2 IL])) // NFC R12 X-rate (YTD Based) IL: The R12-value multiplied with the rate at the that specific Reporting period. // The calculation is done for one company at the time due to difference in base_currency. // LASTBLANKVALUE function is used to present the value from the last available Reporting period when presenting on Quarter, Half year or Year level.
ACT YTD XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	SUMX ( VALUES ( COMPANY[ID] ), LASTNONBLANKVALUE('REPORTING PERIOD'[ID],[ACT YTD IL]*[Conversion rate XR2 IL])) // ACT YTD X-rate (YTD Based) IL: The YTD value multiplied with the current rate. // LASTNONBLANKVALUE to handle TOTALS at Quarter and Year level to be the value from the last period within the quarter or year. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates. // If ever to update this code: Heads up on verifing the results on Quarter and Year level in the multi-company scenario.
BUD YTD XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	SUMX ( VALUES ( COMPANY[ID] ), LASTNONBLANKVALUE('REPORTING PERIOD'[ID],[BUD YTD IL]*[Conversion rate XR2 IL])) // BUD YTD X-rate (YTD Based) IL: The YTD value multiplied with the current rate. // LASTNONBLANKVALUE to handle TOTALS at Quarter and Year level to be the value from the last period within the quarter or year. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates. // If ever to update this code: Heads up on verifing the results on Quarter and Year level in the multi-company scenario.
CFC YTD XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	SUMX ( VALUES ( COMPANY[ID] ), LASTNONBLANKVALUE('REPORTING PERIOD'[ID],[CFC YTD IL]*[Conversion rate XR2 IL])) // CFC YTD X-rate (YTD Based) IL: The YTD value multiplied with the current rate. // LASTNONBLANKVALUE to handle TOTALS at Quarter and Year level to be the value from the last period within the quarter or year. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates. // If ever to update this code: Heads up on verifing the results on Quarter and Year level in the multi-company scenario.
NFC YTD XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	SUMX ( VALUES ( COMPANY[ID] ), LASTNONBLANKVALUE('REPORTING PERIOD'[ID],[NFC YTD IL]*[Conversion rate XR2 IL])) // NFC YTD X-rate (YTD Based) IL: The YTD value multiplied with the current rate. // LASTNONBLANKVALUE to handle TOTALS at Quarter and Year level to be the value from the last period within the quarter or year. // VALUES-statement to handle the multi-company scenario where companies have different conversion rates. // If ever to update this code: Heads up on verifing the results on Quarter and Year level in the multi-company scenario.
ACT XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	VAR CurrPeriod = MAX('REPORTING PERIOD'[Reporting Period]) RETURN IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), IF( CurrPeriod = 1, SUMX (VALUES ( COMPANY[ID] ), ([ACT IL][Conversion rate XR2 IL]) ), SUMX (VALUES ( COMPANY[ID] ), ([ACT YTD IL][Conversion rate XR2 IL]) - ([ACT OB IL][Conversion rate PP XR2 IL])) ) ) // ACT X-rate (YTD Based) IL: (ACT YTD X-rate) minus (OB rate in previous period). Note that OB is the same as the YTD-value in the previous period. // In case no addition of ACT from previous period, this is just the effect of the same YTD value being multiplied with rate in previous period compared with the rate in this period. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level. HasOnValuePeriod is to ensure Blank values.
BUD XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	VAR CurrPeriod = MAX('REPORTING PERIOD'[Reporting Period]) RETURN IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), IF( CurrPeriod = 1, SUMX (VALUES ( COMPANY[ID] ), ([BUD IL][Conversion rate XR2 IL]) ), SUMX (VALUES ( COMPANY[ID] ), ([BUD YTD IL][Conversion rate XR2 IL]) - ([BUD OB IL][Conversion rate PP XR2 IL])) ) ) // BUD X-rate (YTD Based) IL: (BUD YTD X-rate) minus (OB rate in previous period). Note that OB is the same as the YTD-value in the previous period. // In case no addition of BUD from previous period, this is just the effect of the same YTD value being multiplied with rate in previous period compared with the rate in this period. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level. HasOnValuePeriod is to ensure Blank values.
CFC XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	VAR CurrPeriod = MAX('REPORTING PERIOD'[Reporting Period]) RETURN IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), IF( CurrPeriod = 1, SUMX (VALUES ( COMPANY[ID] ), ([CFC IL][Conversion rate XR2 IL]) ), SUMX (VALUES ( COMPANY[ID] ), ([CFC YTD IL][Conversion rate XR2 IL]) - ([CFC OB IL][Conversion rate PP XR2 IL])) ) ) // CFC X-rate (YTD Based) IL: (CFC YTD X-rate) minus (OB rate in previous period). Note that OB is the same as the YTD-value in the previous period. // In case no addition of CFC from previous period, this is just the effect of the same YTD value being multiplied with rate in previous period compared with the rate in this period. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level. HasOnValuePeriod is to ensure Blank values.
NFC XR2 (YTD Based) IL	Y	Y	IL version of same GL measure		N	VAR CurrPeriod = MAX('REPORTING PERIOD'[Reporting Period]) RETURN IF('IL ANALYSIS MEASURES'[HasOneValuePeriod IL] = FALSE(), BLANK(), IF( CurrPeriod = 1, SUMX (VALUES ( COMPANY[ID] ), ([NFC IL][Conversion rate XR2 IL]) ), SUMX (VALUES ( COMPANY[ID] ), ([NFC YTD IL][Conversion rate XR2 IL]) - ([NFC OB IL][Conversion rate PP XR2 IL])) ) ) // NFC X-rate (YTD Based) IL: (NFC YTD X-rate) minus (OB rate in previous period). Note that OB is the same as the YTD-value in the previous period. // In case no addition of NFC from previous period, this is just the effect of the same YTD value being multiplied with rate in previous period compared with the rate in this period. // NOTE: This measure can only to be presented on Reporting Period level. Can not be used on Quarter, Half year or Year level. HasOnValuePeriod is to ensure Blank values.
ACT (Acc Calendar) IL	Y	N	IL version of same GL measure		N	IF (HASONEVALUE('ACCOUNTING PERIOD'[Accounting Year]), SUMX('IL ANALYSIS', [ACT_OB_PERIOD_DOM] + [ACT_PERIOD_DOM])) // ACTUAL IL in Accounting currency. // Mandatory to use Accounting calendar for this measure to function. // Uses the HASONEVALUE function to suppress display of totals that sum up multiple years.
ACT OB (Acc Calendar) IL	Y	Y	IL version of same GL measure		N	VAR CurrAccYear = SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Year]) // Uses the SELECTEDVALUE function to suppress display of totals that sum up multiple years. Var CurrAccPeriod = IF( SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No]) = 0, 1, SELECTEDVALUE('ACCOUNTING PERIOD'[Accounting Period No])) VAR RunningTotal= CALCULATE( [ACT (Acc Calendar) IL], FILTER(ALL('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year]=CurrAccYear && 'ACCOUNTING PERIOD'[Accounting Period No]< CurrAccPeriod)) RETURN RunningTotal // ACTUAL IL Opening Balance in Accounting currency. // Mandatory to use Accounting calendar for this measure to function.
ACT YTD (Acc Calendar) IL	Y	Y	IL version of same GL measure		N	VAR CurrentAccPeriodNo = MAX('ACCOUNTING PERIOD'[Accounting Period No]) VAR CurrentAccYear = MAX('ACCOUNTING PERIOD'[Accounting Year]) VAR RunningTotal = CALCULATE([ACT (Acc Calendar) IL], FILTER(ALL('ACCOUNTING PERIOD'), 'ACCOUNTING PERIOD'[Accounting Year] = CurrentAccYear && 'ACCOUNTING PERIOD'[Accounting Period No] <= CurrentAccPeriodNo)) RETURN IF( HASONEVALUE('ACCOUNTING PERIOD'[Accounting Year]), RunningTotal) // ACTUAL YTD in Accounting currency. // Mandatory to use Accounting calendar for this measure to function. // Uses the HASONEVALUE function to suppress display of totals that sum up multiple years.
Switch Actual (Acc Calendar) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected Actual Measure], "ACT", [ACT (Acc Calendar) IL], "ACT YTD", [ACT YTD (Acc Calendar) IL] ) // Two measures to switch between, ACT IL and ACT YTD IL. // Mandatory to use Accounting calendar for this measure to function. // Mandatory to filter a single value from tables SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
ACT IL	Y	N	IL version of same GL measure		N	SUM('IL ANALYSIS'[ACT_PERIOD_DOM]) // ACTUAL IL in Accounting Currency, use Reporting calendar.
Diff GL vs IL (ACT)	Y	N	Difference between ACT GL and ACT IL		N	[ACT] - [ACT IL] // ACT GL - ACT IL in Accounting currency, use reporting calendar.
Diff GL vs IL (BUD)	Y	N	Difference between BUD GL and BUD IL		N	[BUD] - [BUD IL]
Diff GL vs IL (ACT)(%)	Y	N	Difference(%) between ACT GL and ACT IL		N	DIVIDE([Diff GL vs IL (ACT)],ABS([ACT IL]), Blank()) // % difference ACT GL - ACT IL in Accounting currency, use reporting calendar.
Diff GL vs IL (BUD)(%)	Y	N	Difference(%) between BUD GL and BUD IL		N	DIVIDE([Diff GL vs IL (BUD)],ABS([BUD IL]), Blank()) // % difference BUDGET GL - BUDGET IL in Accounting currency, use reporting calendar.
Diff GL vs IL (CFC)	Y	N	Difference between CFC GL and CFC IL		N	[CFC] - [CFC IL] // CURRENT FORECAST GL - CURRENT FORECAST IL in Accounting currency, use reporting calendar.
Diff GL vs IL (CFC)(%)	Y	N	Difference(%) between CFC GL and CFC IL		N	DIVIDE([Diff GL vs IL (CFC)],ABS([CFC IL]), Blank()) // % difference CURRENT FORECAST GL - CURRENT FORECAST IL in Accounting currency, use reporting calendar.
Diff GL vs IL (NFC)	Y	N	Difference between NFC GL and NFC IL		N	[NFC] - [NFC IL] // NEXT FORECAST GL - NEXT FORECAST IL in Accounting currency, use reporting calendar.
Diff GL vs IL (NFC)(%)	Y	N	Difference(%) between NFC GL and NFC IL		N	DIVIDE([Diff GL vs IL (NFC)],ABS([NFC IL]), Blank()) // % difference NEXT FORECAST GL - NEXT FORECAST IL in Accounting currency, use reporting calendar.
Diff GL vs IL (ACT Acc Calendar)	Y	N	Difference between ACT GL and ACT IL by accounting calendar		N	[ACT (Acc Calendar)] - [ACT (Acc Calendar) IL] // ACT GL - ACT IL in Accounting currency // Mandatory to use Accounting calendar for this measure to function.
Diff GL vs IL (ACT Acc Calendar)(%)	Y	N	Difference(%) between ACT GL and ACT IL by accounting calendar		N	DIVIDE([Diff GL vs IL (ACT Acc Calendar)],ABS([ACT (Acc Calendar) IL]), Blank()) // % difference ACT GL vs ACT IL in Accounting currency // Mandatory to use Accounting calendar for this measure to function.
Diff GL vs IL (ACT YTD Acc Calendar)	Y	N	Difference between ACT YTD GL and ACT YTD IL by accounting calendar		N	[ACT YTD (Acc Calendar)] - [ACT YTD (Acc Calendar) IL] // ACT YTD GL - ACT YTD IL in Accounting currency // Mandatory to use Accounting calendar for this measure to function.
Diff GL vs IL (ACT YTD Acc Calendar)(%)	Y	N	Difference(%) between ACT YTD GL and ACT YTD IL by accounting calendar		N	DIVIDE([Diff GL vs IL (ACT YTD Acc Calendar)],ABS([ACT YTD (Acc Calendar) IL]), Blank()) // % difference ACT YTD GL vs ACT YTD IL in Accounting currency // Mandatory to use Accounting calendar for this measure to function.
Diff GL vs IL (ACT Trans)	Y	N	Difference between ACT GL and ACT IL, in transaction currency		N	[ACT Trans] - [ACT Trans IL] // ACT GL - ACT IL in Transaction currency, use reporting calendar.
Diff GL vs IL (BUD Trans)	Y	N	Difference between BUD GL and BUD IL, in transaction currency		N	[BUD Trans] - [BUD Trans IL] // BUD GL - BUD IL in Transaction currency, use reporting calendar.
Diff GL vs IL (CFC Trans)	Y	N	Difference between CFC GL and CFC IL, in transaction currency		N	[CFC Trans] - [CFC Trans IL] // CFC GL - CFC IL in Transaction currency, use reporting calendar.
Diff GL vs IL (NFC Trans)	Y	N	Difference between NFC GL and NFC IL, in transaction currency		N	[NFC Trans] - [NFC Trans IL] // NFC GL - NFC IL in Transaction currency, use reporting calendar.
Diff GL vs IL (ACT Trans)(%)	Y	N	Difference(%) between ACT GL and ACT IL, in transaction currency		N	DIVIDE([Diff GL vs IL (ACT Trans)],ABS([ACT Trans IL]), Blank()) // % difference ACT GL - ACT IL in Transaction currency, use reporting calendar.
Diff GL vs IL (BUD Trans)(%)	Y	N	Difference(%) between BUD GL and BUD IL, in transaction currency		N	DIVIDE([Diff GL vs IL (BUD Trans)],ABS([BUD Trans IL]), Blank()) // % difference BUD GL - BUD IL in Transaction currency, use reporting calendar.
Diff GL vs IL (CFC Trans)(%)	Y	N	Difference(%) between CFC GL and CFC IL, in transaction currency		N	DIVIDE([Diff GL vs IL (CFC Trans)],ABS([CFC Trans IL]), Blank()) // % difference CFC GL - CFC IL in Transaction currency, use reporting calendar.
Diff GL vs IL (NFC Trans)(%)	Y	N	Difference(%) between NFC GL and NFC IL, in transaction currency		N	DIVIDE([Diff GL vs IL (NFC Trans)],ABS([NFC Trans IL]), Blank()) // % difference NFC GL - NFC IL in Transaction currency, use reporting calendar.
Diff GL vs IL (ACT XR1 Period Based)	Y	N	Difference between ACT GL and ACT IL, in XR1(Period Based) currency		N	[ACT XR1 (Period Based)] - [ACT XR1 (Period Based) IL] // ACT GL - ACT IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (BUD XR1 Period Based)	Y	N	Difference between BUD GL and BUD IL, in XR1(Period Based) currency		N	[BUD XR1 (Period Based)] - [BUD XR1 (Period Based) IL] // BUD GL - BUD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (CFC XR1 Period Based)	Y	N	Difference between CFC GL and CFC IL, in XR1(Period Based) currency		N	[CFC XR1 (Period Based)] - [CFC XR1 (Period Based) IL] // CFC GL - CFC IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (NFC XR1 Period Based)	Y	N	Difference between NFC GL and NFC IL, in XR1(Period Based) currency		N	[NFC XR1 (Period Based)] - [NFC XR1 (Period Based) IL] // NFC GL - NFC IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (ACT XR1 Period Based)(%)	Y	N	Difference(%) between ACT GL and ACT IL, in XR1(Period Based) currency		N	DIVIDE([Diff GL vs IL (ACT XR1 Period Based)],ABS([ACT XR1 (Period Based) IL]), Blank()) // % difference ACT GL - ACT IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (BUD XR1 Period Based)(%)	Y	N	Difference(%) between BUD GL and BUD IL, in XR1(Period Based) currency		N	DIVIDE([Diff GL vs IL (BUD XR1 Period Based)],ABS([BUD XR1 (Period Based) IL]), Blank()) // % difference BUD GL - BUD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (CFC XR1 Period Based)(%)	Y	N	Difference(%) between CFC GL and CFC IL, in XR1(Period Based) currency		N	DIVIDE([Diff GL vs IL (CFC XR1 Period Based)],ABS([CFC XR1 (Period Based) IL]), Blank()) // % difference CFC GL - CFC IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (NFC XR1 Period Based)(%)	Y	N	Difference(%) between NFC GL and NFC IL, in XR1(Period Based) currency		N	DIVIDE([Diff GL vs IL (NFC XR1 Period Based)],ABS([NFC XR1 (Period Based) IL]), Blank()) // % difference NFC GL - NFC IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (ACT XR2 Period Based)	Y	N	Difference between ACT GL and ACT IL, in XR2(Period Based) currency		N	[ACT XR2 (Period Based)] - [ACT XR2 (Period Based) IL] // ACT GL - ACT IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (ACT XR2 Period Based)(%)	Y	N	Difference(%) between ACT GL and ACT IL, in XR2(Period Based) currency		N	DIVIDE([Diff GL vs IL (ACT XR2 Period Based)],ABS([ACT XR2 (Period Based) IL]), Blank()) // % difference ACT GL - ACT IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (BUD XR2 Period Based)	Y	N	Difference between BUD GL and BUD IL, in in XR2(Period Based) currency		N	[BUD XR2 (Period Based)] - [BUD XR2 (Period Based) IL] // BUD GL - BUD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (BUD XR2 Period Based)(%)	Y	N	Difference(%) between BUD GL and BUD IL, in XR2(Period Based) currency		N	DIVIDE([Diff GL vs IL (BUD XR2 Period Based)],ABS([BUD XR2 (Period Based) IL]), Blank()) // % difference BUD GL - BUD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (CFC XR2 Period Based)	Y	N	Difference between CFC GL and CFC IL, in XR2(Period Based) currency		N	[CFC XR2 (Period Based)] - [CFC XR2 (Period Based) IL] // CFC GL - CFC IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (CFC XR2 Period Based)(%)	Y	N	Difference(%) between CFC GL and CFC IL, in XR2(Period Based) currency		N	DIVIDE([Diff GL vs IL (CFC XR2 Period Based)],ABS([CFC XR2 (Period Based) IL]), Blank()) // % difference CFC GL - CFC IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (NFC XR2 Period Based)	Y	N	Difference between NFC GL and NFC IL, in XR2(Period Based) currency		N	[NFC XR2 (Period Based)] - [NFC XR2 (Period Based) IL] // NFC GL - NFC IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (NFC XR2 Period Based)(%)	Y	N	Difference(%) between NFC GL and NFC IL, in XR2(Period Based) currency		N	DIVIDE([Diff GL vs IL (NFC XR2 Period Based)],ABS([NFC XR2 (Period Based) IL]), Blank()) // % difference NFC GL - NFC IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (ACT XR1 YTD Based)	Y	N	Difference between ACT GL and ACT IL, in XR1(YTD Based) currency		N	[ACT XR1 (YTD Based)] - [ACT XR1 (YTD Based) IL] // ACT GL - ACT IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (ACT XR1 YTD Based)(%)	Y	N	Difference(%) between ACT GL and ACT IL, in XR1(YTD Based) currency		N	DIVIDE([Diff GL vs IL (ACT XR1 YTD Based)],ABS([ACT XR1 (YTD Based) IL]), Blank()) // % difference ACT GL - ACT IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (BUD XR1 YTD Based)	Y	N	Difference between BUD GL and BUD IL, in XR1(YTD Based) currency		N	[BUD XR1 (YTD Based)] - [BUD XR1 (YTD Based) IL] // BUD GL - BUD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (BUD XR1 YTD Based)(%)	Y	N	Difference(%) between BUD GL and BUD IL, in XR1(YTD Based) currency		N	DIVIDE([Diff GL vs IL (BUD XR1 YTD Based)],ABS([BUD XR1 (YTD Based) IL]), Blank()) // % difference BUD GL - BUD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (CFC XR1 YTD Based)	Y	N	Difference between CFC GL and CFC IL, in XR1(YTD Based) currency		N	[CFC XR1 (YTD Based)] - [CFC XR1 (YTD Based) IL] // CFC GL - CFC IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (CFC XR1 YTD Based)(%)	Y	N	Difference(%) between CFC GL and CFC IL, in XR1(YTD Based) currency		N	DIVIDE([Diff GL vs IL (CFC XR1 YTD Based)],ABS([CFC XR1 (YTD Based) IL]), Blank()) // % difference CFC GL - CFC IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (NFC XR1 YTD Based)	Y	N	Difference between NFC GL and NFC IL, in XR1(YTD Based) currency		N	[NFC XR1 (YTD Based)] - [NFC XR1 (YTD Based) IL] // NFC GL - NFC IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (NFC XR1 YTD Based)(%)	Y	N	Difference(%) between NFC GL and NFC IL, in XR1(YTD Based) currency		N	DIVIDE([Diff GL vs IL (NFC XR1 YTD Based)],ABS([NFC XR1 (YTD Based) IL]), Blank())
Diff GL vs IL (ACT XR2 YTD Based)	Y	N	Difference between ACT GL and ACT IL, in XR2(YTD Based) currency		N	[ACT XR2 (YTD Based)] - [ACT XR2 (YTD Based) IL] // ACT GL - ACT IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (ACT XR2 YTD Based)(%)	Y	N	Difference(%) between ACT GL and ACT IL, in XR2(YTD Based) currency		N	DIVIDE([Diff GL vs IL (ACT XR2 YTD Based)],ABS([ACT XR2 (YTD Based) IL]), Blank()) // % difference ACT GL - ACT IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (BUD XR2 YTD Based)	Y	N	Difference between BUD GL and BUD IL, in XR2(YTD Based) currency		N	[BUD XR2 (YTD Based)] - [BUD XR2 (YTD Based) IL] // BUD GL - BUD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (BUD XR2 YTD Based)(%)	Y	N	Difference(%) between BUD GL and BUD IL, in XR2(YTD Based) currency		N	DIVIDE([Diff GL vs IL (BUD XR2 YTD Based)],ABS([BUD XR2 (YTD Based) IL]), Blank()) // % difference BUD GL - BUD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (CFC XR2 YTD Based)	Y	N	Difference between CFC GL and CFC IL, in XR2(YTD Based) currency		N	[CFC XR2 (YTD Based)] - [CFC XR2 (YTD Based) IL] // CFC GL - CFC IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (CFC XR2 YTD Based)(%)	Y	N	Difference(%) between CFC GL and CFC IL, in XR2(YTD Based) currency		N	DIVIDE([Diff GL vs IL (CFC XR2 YTD Based)],ABS([CFC XR2 (YTD Based) IL]), Blank()) // % difference CFC GL - CFC IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (NFC XR2 YTD Based)	Y	N	Difference between NFC GL and NFC IL, in XR2(YTD Based) currency		N	[NFC XR2 (YTD Based)] - [NFC XR2 (YTD Based) IL] // NFC GL - NFC IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (NFC XR2 YTD Based)(%)	Y	N	Difference(%) between NFC GL and NFC IL, in XR2(YTD Based) currency		N	DIVIDE([Diff GL vs IL (NFC XR2 YTD Based)],ABS([NFC XR2 (YTD Based) IL]), Blank()) // % difference NFC GL - NFC IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (ACT YTD)	Y	N	Difference between ACT YTD GL and ACT YTD IL		N	[ACT YTD] - [ACT YTD IL] // ACT YTD GL - ACT YTD IL in Accounting currency, use reporting calendar.
Diff GL vs IL (BUD YTD)	Y	N	Difference between BUD YTD GL and BUD YTD IL		N	[BUD YTD] - [BUD YTD IL] // BUDGET YTD GL - BUDGET YTD IL in Accounting currency, use reporting calendar.
Diff GL vs IL (CFC YTD)	Y	N	Difference between CFC YTD GL and CFC YTD IL		N	[CFC YTD] - [CFC YTD IL] // CURRENT FORECAST YTD GL - CURRENT FORECAST YTD IL in Accounting currency, use reporting calendar.
Diff GL vs IL (NFC YTD)	Y	N	Difference between NFC YTD GL and NFC YTD IL		N	[NFC YTD] - [NFC YTD IL] // NEXT FORECAST YTD GL - NEXT FORECAST YTD IL in Accounting currency, use reporting calendar.
Diff GL vs IL (ACT YTD)(%)	Y	N	Difference(%) between ACT YTD GL and ACT YTD IL		N	DIVIDE([Diff GL vs IL (ACT YTD)],ABS([ACT YTD IL]), Blank()) // % difference ACT YTD GL - ACT YTD IL in Accounting currency, use reporting calendar.
Diff GL vs IL (BUD YTD)(%)	Y	N	Difference(%) between BUD YTD GL and BUD YTD IL		N	DIVIDE([Diff GL vs IL (BUD YTD)],ABS([BUD YTD IL]), Blank()) // % difference BUDGET YTD GL - BUDGET YTD IL in Accounting currency, use reporting calendar.
Diff GL vs IL (CFC YTD)(%)	Y	N	Difference(%) between CFC YTD GL and CFC YTD IL		N	DIVIDE([Diff GL vs IL (CFC YTD)],ABS([CFC YTD IL]), Blank()) // % difference CURRENT FORECAST YTD GL - CURRENT FORECAST YTD IL in Accounting currency, use reporting calendar.
Diff GL vs IL (NFC YTD)(%)	Y	N	Difference(%) between NFC YTD GL and NFC YTD IL		N	DIVIDE([Diff GL vs IL (NFC YTD)],ABS([NFC YTD IL]), Blank()) // % difference NEXT FORECAST YTD GL - NEXT FORECAST YTD IL in Accounting currency, use reporting calendar.
Diff GL vs IL (ACT YTD Trans)	Y	N	Difference between ACT YTD GL and ACT YTD IL, in transaction currency		N	[ACT YTD Trans] - [ACT YTD Trans IL] // ACT YTD GL - ACT YTD IL in Transaction currency, use reporting calendar.
Diff GL vs IL (BUD YTD Trans)	Y	N	Difference between BUD YTD GL and BUD YTD IL, in transaction currency		N	[BUD YTD Trans] - [BUD YTD Trans IL] // BUD YTD GL - BUD YTD IL in Transaction currency, use reporting calendar.
Diff GL vs IL (CFC YTD Trans)	Y	N	Difference between CFC YTD GL and CFC YTD IL, in transaction currency		N	[CFC YTD Trans] - [CFC YTD Trans IL] // CFC YTD GL - CFC YTD IL in Transaction currency, use reporting calendar.
Diff GL vs IL (NFC YTD Trans)	Y	N	Difference between NFC YTD GL and NFC YTD IL, in transaction currency		N	[NFC YTD Trans] - [NFC YTD Trans IL] // NFC YTD GL - NFC YTD IL in Transaction currency, use reporting calendar.
Diff GL vs IL (ACT YTD Trans)(%)	Y	N	Difference(%) between ACT YTD GL and ACT YTD IL, in transaction currency		N	DIVIDE([Diff GL vs IL (ACT YTD Trans)],ABS([ACT YTD Trans IL]), Blank()) // % difference ACT YTD GL - ACT YTD IL in Transaction currency, use reporting calendar.
Diff GL vs IL (BUD YTD Trans)(%)	Y	N	Difference(%) between BUD YTD GL and BUD YTD IL, in transaction currency		N	DIVIDE([Diff GL vs IL (BUD YTD Trans)],ABS([BUD YTD Trans IL]), Blank()) // % difference BUD YTD GL - BUD YTD IL in Transaction currency, use reporting calendar.
Diff GL vs IL (CFC YTD Trans)(%)	Y	N	Difference(%) between CFC YTD GL and CFC YTD IL, in transaction currency		N	DIVIDE([Diff GL vs IL (CFC YTD Trans)],ABS([CFC YTD Trans IL]), Blank()) // % difference CFC YTD GL - CFC YTD IL in Transaction currency, use reporting calendar.
Diff GL vs IL (NFC YTD Trans)(%)	Y	N	Difference(%) between NFC YTD GL and NFC YTD IL, in transaction currency		N	DIVIDE([Diff GL vs IL (NFC YTD Trans)],ABS([NFC YTD Trans IL]), Blank()) // % difference NFC YTD GL - NFC YTD IL in Transaction currency, use reporting calendar.
Diff GL vs IL (ACT YTD XR1 Period Based)	Y	N	Difference between ACT YTD GL and ACT YTD IL, in XR1(Period Based) currency		N	[ACT YTD XR1 (Period Based)] - [ACT YTD XR1 (Period Based) IL] // ACT YTD GL - ACT YTD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (ACT YTD XR1 Period Based)(%)	Y	N	Difference(%) between ACT YTD GL and ACT YTD IL, in XR1(Period Based) currency		N	DIVIDE([Diff GL vs IL (ACT YTD XR1 Period Based)],ABS([ACT YTD XR1 (Period Based) IL]), Blank()) // % difference ACT YTD GL - ACT YTD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (BUD YTD XR1 Period Based)	Y	N	Difference between BUD YTD GL and BUD YTD IL, in XR1(Period Based) currency		N	[BUD YTD XR1 (Period Based)] - [BUD YTD XR1 (Period Based) IL] // BUD YTD GL - BUD YTD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (BUD YTD XR1 Period Based)(%)	Y	N	Difference(%) between BUD YTD GL and BUD YTD IL, in XR1(Period Based) currency		N	DIVIDE([Diff GL vs IL (BUD YTD XR1 Period Based)],ABS([BUD YTD XR1 (Period Based) IL]), Blank()) // % difference BUD YTD GL - BUD YTD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (CFC YTD XR1 Period Based)	Y	N	Difference between CFC YTD GL and CFC YTD IL, in XR1(Period Based) currency		N	[CFC YTD XR1 (Period Based)] - [CFC YTD XR1 (Period Based) IL] // CFC YTD GL - CFC YTD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (CFC YTD XR1 Period Based)(%)	Y	N	Difference(%) between CFC YTD GL and CFC YTD IL, in XR1(Period Based) currency		N	DIVIDE([Diff GL vs IL (CFC YTD XR1 Period Based)],ABS([CFC YTD XR1 (Period Based) IL]), Blank()) // % difference CFC YTD GL - CFC YTD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (NFC YTD XR1 Period Based)	Y	N	Difference between NFC YTD GL and NFC YTD IL, in XR1(Period Based) currency		N	[NFC YTD XR1 (Period Based)] - [NFC YTD XR1 (Period Based) IL] // NFC YTD GL - NFC YTD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (NFC YTD XR1 Period Based)(%)	Y	N	Difference(%) between NFC YTD GL and NFC YTD IL, in XR1(Period Based) currency		N	DIVIDE([Diff GL vs IL (NFC YTD XR1 Period Based)],ABS([NFC YTD XR1 (Period Based) IL]), Blank()) // % difference NFC YTD GL - NFC YTD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (ACT YTD XR1 YTD Based)	Y	N	Difference between ACT YTD GL and ACT YTD IL, in XR1(YTD Based) currency		N	[ACT YTD XR1 (YTD Based)] - [ACT YTD XR1 (YTD Based) IL] // ACT YTD GL - ACT YTD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (ACT YTD XR1 YTD Based)(%)	Y	N	Difference(%) between ACT YTD GL and ACT YTD IL, in XR1(YTD Based) currency		N	DIVIDE([Diff GL vs IL (ACT YTD XR1 YTD Based)],ABS([ACT YTD XR1 (YTD Based) IL]), Blank()) // % difference ACT YTD GL - ACT YTD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (BUD YTD XR1 YTD Based)	Y	N	Difference between BUD YTD GL and BUD YTD IL, in XR1(YTD Based) currency		N	[BUD YTD XR1 (YTD Based)] - [BUD YTD XR1 (YTD Based) IL] // BUD YTD GL - BUD YTD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (BUD YTD XR1 YTD Based)(%)	Y	N	Difference(%) between BUD YTD GL and BUD YTD IL, in XR1(YTD Based) currency		N	DIVIDE([Diff GL vs IL (BUD YTD XR1 YTD Based)],ABS([BUD YTD XR1 (YTD Based) IL]), Blank()) // % difference BUD YTD GL - BUD YTD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (CFC YTD XR1 YTD Based)	Y	N	Difference between CFC YTD GL and CFC YTD IL, in XR1(YTD Based) currency		N	[CFC YTD XR1 (YTD Based)] - [CFC YTD XR1 (YTD Based) IL] // CFC YTD GL - CFC YTD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (CFC YTD XR1 YTD Based)(%)	Y	N	Difference(%) between CFC YTD GL and CFC YTD IL, in XR1(YTD Based) currency		N	DIVIDE([Diff GL vs IL (CFC YTD XR1 YTD Based)],ABS([CFC YTD XR1 (YTD Based) IL]), Blank()) // % difference CFC YTD GL - CFC YTD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (NFC YTD XR1 YTD Based)	Y	N	Difference between NFC YTD GL and NFC YTD IL, in XR1(YTD Based) currency		N	[NFC YTD XR1 (YTD Based)] - [NFC YTD XR1 (YTD Based) IL] // NFC YTD GL - NFC YTD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (NFC YTD XR1 YTD Based)(%)	Y	N	Difference(%) between NFC YTD GL and NFC YTD IL, in XR1(YTD Based) currency		N	DIVIDE([Diff GL vs IL (NFC YTD XR1 YTD Based)],ABS([NFC YTD XR1 (YTD Based) IL]), Blank()) // % difference NFC YTD GL - NFC YTD IL in X-rate 1 currency, use reporting calendar.
Diff GL vs IL (ACT YTD XR2 Period Based)	Y	N	Difference between ACT YTD GL and ACT YTD IL, in XR2(Period Based) currency		N	[ACT YTD XR2 (Period Based)] - [ACT YTD XR2 (Period Based) IL] // ACT YTD GL - ACT YTD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (ACT YTD XR2 Period Based)(%)	Y	N	Difference(%) between ACT YTD GL and ACT YTD IL, in XR2(Period Based) currency		N	DIVIDE([Diff GL vs IL (ACT YTD XR2 Period Based)],ABS([ACT YTD XR2 (Period Based) IL]), Blank()) // % difference ACT YTD GL - ACT YTD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (BUD YTD XR2 Period Based)	Y	N	Difference between BUD YTD GL and BUD YTD IL, in XR2(Period Based) currency		N	[BUD YTD XR2 (Period Based)] - [BUD YTD XR2 (Period Based) IL] // BUD YTD GL - BUD YTD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (BUD YTD XR2 Period Based)(%)	Y	N	Difference(%) between BUD YTD GL and BUD YTD IL, in XR2(Period Based) currency		N	DIVIDE([Diff GL vs IL (BUD YTD XR2 Period Based)],ABS([BUD YTD XR2 (Period Based) IL]), Blank()) // % difference BUD YTD GL - BUD YTD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (CFC YTD XR2 Period Based)	Y	N	Difference between CFC YTD GL and CFC YTD IL, in XR2(Period Based) currency		N	[CFC YTD XR2 (Period Based)] - [CFC YTD XR2 (Period Based) IL] // CFC YTD GL - CFC YTD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (CFC YTD XR2 Period Based)(%)	Y	N	Difference(%) between CFC YTD GL and CFC YTD IL, in XR2(Period Based) currency		N	DIVIDE([Diff GL vs IL (CFC YTD XR2 Period Based)],ABS([CFC YTD XR2 (Period Based) IL]), Blank()) // % difference CFC YTD GL - CFC YTD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (NFC YTD XR2 Period Based)	Y	N	Difference between NFC YTD GL and NFC YTD IL, in XR2(Period Based) currency		N	[NFC YTD XR2 (Period Based)] - [NFC YTD XR2 (Period Based) IL] // NFC YTD GL - NFC YTD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (NFC YTD XR2 Period Based)(%)	Y	N	Difference(%) between NFC YTD GL and NFC YTD IL, in XR2(Period Based) currency		N	DIVIDE([Diff GL vs IL (NFC YTD XR2 Period Based)],ABS([NFC YTD XR2 (Period Based) IL]), Blank()) // % difference NFC YTD GL - NFC YTD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (ACT YTD XR2 YTD Based)	Y	N	Difference between ACT YTD GL and ACT YTD IL, in XR2(YTD Based) currency		N	[ACT YTD XR2 (YTD Based)] - [ACT YTD XR2 (YTD Based) IL] // ACT YTD GL - ACT YTD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (ACT YTD XR2 YTD Based)(%)	Y	N	Difference(%) between ACT YTD GL and ACT YTD IL, in XR2(YTD Based) currency		N	DIVIDE([Diff GL vs IL (ACT YTD XR2 YTD Based)],ABS([ACT YTD XR2 (YTD Based) IL]), Blank()) // % difference ACT YTD GL - ACT YTD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (BUD YTD XR2 YTD Based)	Y	N	Difference between BUD YTD GL and BUD YTD IL, in XR2(YTD Based) currency		N	[BUD YTD XR2 (YTD Based)] - [BUD YTD XR2 (YTD Based) IL] // BUD YTD GL - BUD YTD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (BUD YTD XR2 YTD Based)(%)	Y	N	Difference(%) between BUD YTD GL and BUD YTD IL, in XR2(YTD Based) currency		N	DIVIDE([Diff GL vs IL (BUD YTD XR2 YTD Based)],ABS([BUD YTD XR2 (YTD Based) IL]), Blank()) // % difference BUD YTD GL - BUD YTD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (CFC YTD XR2 YTD Based)	Y	N	Difference between CFC YTD GL and CFC YTD IL, in XR2(YTD Based) currency		N	[CFC YTD XR2 (YTD Based)] - [CFC YTD XR2 (YTD Based) IL] // CFC YTD GL - CFC YTD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (CFC YTD XR2 YTD Based)(%)	Y	N	Difference(%) between CFC YTD GL and CFC YTD IL, in XR2(YTD Based) currency		N	DIVIDE([Diff GL vs IL (CFC YTD XR2 YTD Based)],ABS([CFC YTD XR2 (YTD Based) IL]), Blank()) // % difference CFC YTD GL - CFC YTD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (NFC YTD XR2 YTD Based)	Y	N	Difference between NFC YTD GL and NFC YTD IL, in XR2(YTD Based) currency		N	[NFC YTD XR2 (YTD Based)] - [NFC YTD XR2 (YTD Based) IL] // NFC YTD GL - NFC YTD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (NFC YTD XR2 YTD Based)(%)	Y	N	Difference(%) between NFC YTD GL and NFC YTD IL, in XR2(YTD Based) currency		N	DIVIDE([Diff GL vs IL (NFC YTD XR2 YTD Based)],ABS([NFC YTD XR2 (YTD Based) IL]), Blank()) // % difference NFC YTD GL - NFC YTD IL in X-rate 2 currency, use reporting calendar.
Diff GL vs IL (ACT OB Acc Calendar)	Y	N	Difference between ACT OB GL and ACT OB IL, to present using accounting calendar		N	[ACT OB (Acc Calendar)] - [ACT OB (Acc Calendar) IL] // ACT OB GL - ACT OB IL in Accounting currency // Mandatory to use Accounting calendar for this measure to function.
Diff GL vs IL (ACT OB Acc Calendar)(%)	Y	N	Difference(%) between ACT OB GL and ACT OB IL, to present using accounting calendar		N	DIVIDE([Diff GL vs IL (ACT OB Acc Calendar)],ABS([ACT OB (Acc Calendar) IL]), Blank()) // % difference ACT OB GL vs ACT OB IL in Accounting currency // Mandatory to use Accounting calendar for this measure to function.
BUD PY YTD XR1 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE ( [BUD YTD XR1 (Period Based) IL], DATEADD ( 'REPORTING PERIOD'[ID], -12, MONTH ) ) // BUD PY YTD X-rate (Period Based) IL: BUD YTD Xrate IL from the same reporting period previous year.
BUD PY YTD XR2 (Period Based) IL	Y	Y	IL version of same GL measure		N	CALCULATE ( [BUD YTD XR2 (Period Based) IL], DATEADD ( 'REPORTING PERIOD'[ID], -12, MONTH ) ) // BUD PY YTD X-rate (Period Based) IL: BUD YTD Xrate IL from the same reporting period previous year.
Conversion rate XR1 IL	Y	Y	IL version of same GL measure		N	IF ( HASONEVALUE ( 'CURRENCY CODE X-RATE 1'[Currency Code X-Rate 1] ), VAR SelectedXrateType = SELECTEDVALUE('RATE TYPE X-RATE 1'[Rate Type Code X-Rate 1]) VAR SelectedToCurrency = SELECTEDVALUE ('CURRENCY CODE X-RATE 1'[Currency Code X-Rate 1] ) VAR selected_company = SELECTEDVALUE(COMPANY[ID]) VAR base_currency = CALCULATE( SELECTEDVALUE('IL ANALYSIS'[company_base_currency]), COMPANY[ID] = selected_company, ALL('REPORTING PERIOD') ) VAR LastReportingPeriodWithRate = CALCULATE( MAX('REPORTING PERIOD'[ID]), FILTER( 'X-RATES 1', 'X-RATES 1'[CURRENCY_RATE_TYPE_KEY] = SelectedXrateType && 'X-RATES 1'[TOCURRENCY] = SelectedToCurrency && 'X-RATES 1'[FROMCURRENCY] = base_currency && NOT(ISBLANK('X-RATES 1'[CURRENCYRATE])) ) ) VAR ConversionRate = CALCULATE( MAX('X-RATES 1'[CURRENCYRATE]), 'X-RATES 1'[CURRENCY_RATE_TYPE_KEY] = SelectedXrateType, 'X-RATES 1'[TOCURRENCY] = SelectedToCurrency, 'X-RATES 1'[FROMCURRENCY] = base_currency, 'REPORTING PERIOD'[ID] = LastReportingPeriodWithRate ) RETURN ConversionRate ) // Conversion rate XR1: Rate for the current reporting period. // NOTE: This measure requires that companies never change their "company_base_currency"-value.
Conversion rate PP XR1 IL	Y	Y	IL version of same GL measure		N	CALCULATE([Conversion rate XR1 IL], DATEADD('REPORTING PERIOD'[ID],-1,month)) // Conversion rate XR1 PP IL: Rate for the previous reporting period. // NOTE: This measure requires that companies never change their "company_base_currency"-value.
Conversion rate XR2 IL	Y	Y	IL version of same GL measure		N	IF ( HASONEVALUE ( 'CURRENCY CODE X-RATE 2'[Currency Code X-Rate 2] ), VAR SelectedXrateType = SELECTEDVALUE('RATE TYPE X-RATE 2'[Rate Type Code X-Rate 2]) VAR SelectedToCurrency = SELECTEDVALUE ('CURRENCY CODE X-RATE 2'[Currency Code X-Rate 2] ) VAR selected_company = SELECTEDVALUE(COMPANY[ID]) VAR base_currency = CALCULATE( SELECTEDVALUE('IL ANALYSIS'[company_base_currency]), COMPANY[ID] = selected_company, ALL('REPORTING PERIOD') ) VAR LastReportingPeriodWithRate = CALCULATE( MAX('REPORTING PERIOD'[ID]), FILTER( 'X-RATES 2', 'X-RATES 2'[CURRENCY_RATE_TYPE_KEY] = SelectedXrateType && 'X-RATES 2'[TOCURRENCY] = SelectedToCurrency && 'X-RATES 2'[FROMCURRENCY] = base_currency && NOT(ISBLANK('X-RATES 2'[CURRENCYRATE])) ) ) VAR ConversionRate = CALCULATE( MAX('X-RATES 2'[CURRENCYRATE]), 'X-RATES 2'[CURRENCY_RATE_TYPE_KEY] = SelectedXrateType, 'X-RATES 2'[TOCURRENCY] = SelectedToCurrency, 'X-RATES 2'[FROMCURRENCY] = base_currency, 'REPORTING PERIOD'[ID] = LastReportingPeriodWithRate ) RETURN ConversionRate ) // Conversion rate XR2: Rate for the current reporting period. // NOTE: This measure requires that companies never change their "company_base_currency"-value.
Conversion rate PP XR2 IL	Y	Y	IL version of same GL measure		N	CALCULATE([Conversion rate XR2 IL], DATEADD('REPORTING PERIOD'[ID],-1,month)) // Conversion rate XR2 PP IL: Rate for the previous reporting period. // NOTE: This measure requires that companies never change their "company_base_currency"-value.
Switch Actual (Acc Currency) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected Actual Acc Curr Measure], "ACT", [ACT IL], "ACT YTD", [ACT YTD IL], "ACT R12", [ACT R12 IL] ) // List of measures to switch between, the list includes ACTUAL measures on Accounting currency. // Mandatory to filter a single value from table SWITCH TIME PERSPECTIVE for this measure to function.
Switch Actual (Trans Currency) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected Actual Trans Curr Measure], "ACT Trans", [ACT Trans IL], "ACT YTD Trans", [ACT YTD Trans IL], "ACT R12 Trans", [ACT R12 Trans IL] ) // List of measures to switch between, the list includes ACTUAL measures on Transaction currency. // Mandatory to filter a single value from table SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff XR (YTD Based) IL	Y	N	IL version of same GL measure		N	[Switch Actual (XR1 YTD Based)] - [Switch Actual (XR2 YTD Based)] // Calculates the difference between the SWITCH ACTUAL (XR1 YTD Based) and the SWITCH ACTUAL (XR2 YTD Based). // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff XR (YTD Based) IL (%)	Y	N	IL version of same GL measure		N	DIVIDE([Switch Diff XR (YTD Based)],ABS([Switch Actual (XR2 YTD Based)]), Blank()) // Calculates the % difference between the SWITCH ACTUAL (XR1 YTD Based) and the SWITCH ACTUAL (XR2 YTD Based). // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (CFC) IL	Y	N	IL version of same GL measure		N	[Switch Actual IL] - [Switch Comp (CFC) IL] // Calculates the difference between the SWITCH ACTUAL IL and the SWITCH COMP (CFC) IL. // Mandatory to filter a single value from tables SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (CFC%) IL	Y	N	IL version of same GL measure		N	DIVIDE([Switch Diff (CFC) IL],ABS([Switch Comp (CFC) IL]), Blank()) // Calculates the % difference between the SWITCH ACTUAL IL and the SWITCH COMP (CFC) IL. // Mandatory to filter a single value from tables SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (NFC) IL	Y	N	IL version of same GL measure		N	[Switch Actual IL] - [Switch Comp (NFC) IL] // Calculates the % difference between the SWITCH ACTUAL IL and the SWITCH COMP (NFC) IL. // Mandatory to filter a single value from tables SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (NFC%) IL	Y	N	IL version of same GL measure		N	DIVIDE([Switch Diff (NFC) IL],ABS([Switch Comp (NFC) IL]), Blank()) // Calculates the % difference between the SWITCH ACTUAL IL and the SWITCH COMP (NFC) IL. // Mandatory to filter a single value from tables SWITCH CURRENCY TYPE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Actual (XR1 Period Based) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected Actual XR1 (Period Based) Measure], "ACT XR1 (Period Based)", [ACT XR1 (Period Based) IL], "ACT YTD XR1 (Period Based)", [ACT YTD XR1 (Period Based) IL], "ACT R12 XR1 (Period Based)", [ACT R12 XR1 (Period Based) IL] ) // List of measures to switch between, the list includes ACTUAL measures on XR1 (Period Based) currency. // Mandatory to filter a single value from table SWITCH TIME PERSPECTIVE for this measure to function.
Switch Actual (XR1 YTD Based) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected Actual XR1 (YTD Based) Measure], "ACT XR1 (YTD Based)", [ACT XR1 (YTD Based) IL], "ACT YTD XR1 (YTD Based)", [ACT YTD XR1 (YTD Based) IL], "ACT R12 XR1 (YTD Based)", [ACT R12 XR1 (YTD Based) IL] ) // List of measures to switch between, the list includes ACTUAL measures on XR1 (YTD Based) currency. // Mandatory to filter a single value from table SWITCH TIME PERSPECTIVE for this measure to function.
Switch Actual (XR2 Period Based) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected Actual XR2 (Period Based) Measure], "ACT XR2 (Period Based)", [ACT XR2 (Period Based) IL], "ACT YTD XR2 (Period Based)", [ACT YTD XR2 (Period Based) IL], "ACT R12 XR2 (Period Based)", [ACT R12 XR2 (Period Based) IL] ) // List of measures to switch between, the list includes ACTUAL measures on XR2 (Period Based) currency. // Mandatory to filter a single value from table SWITCH TIME PERSPECTIVE for this measure to function.
Switch Actual (XR2 YTD Based) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected Actual XR2 (YTD Based) Measure], "ACT XR2 (YTD Based)", [ACT XR2 (YTD Based) IL], "ACT YTD XR2 (YTD Based)", [ACT YTD XR2 (YTD Based) IL], "ACT R12 XR2 (YTD Based)", [ACT R12 XR2 (YTD Based) IL] ) // List of measures to switch between, the list includes ACTUAL measures on XR2 (YTD Based) currency. // Mandatory to filter a single value from table SWITCH TIME PERSPECTIVE for this measure to function.
Switch Comp (Acc Currency) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected Comparison Acc Curr Measure], "ACT PY", [ACT PY IL], "BUD", [BUD IL], "CFC", [CFC IL], "NFC", [NFC IL], "ACT PY YTD", [ACT PY YTD IL], "BUD YTD", [BUD YTD IL], "CFC YTD", [CFC YTD IL], "NFC YTD", [NFC YTD IL], "ACT PY R12", [ACT PY R12 IL], "BUD R12", [BUD R12 IL], "CFC R12", [CFC R12 IL], "NFC R12", [NFC R12 IL] ) // List of measures to switch between, the list includes COMPARISON measures on Accounting currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Comp (Trans Currency) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected Comparison Trans Curr Measure], "ACT PY Trans", [ACT PY Trans IL], "BUD Trans", [BUD Trans IL], "CFC Trans", [CFC Trans IL], "NFC Trans", [NFC Trans IL], "ACT PY YTD Trans", [ACT PY YTD Trans IL], "BUD YTD Trans", [BUD YTD Trans IL], "CFC YTD Trans", [CFC YTD Trans IL], "NFC YTD Trans", [NFC YTD Trans IL], "ACT PY R12 Trans", [ACT PY R12 Trans IL], "BUD R12 Trans", [BUD R12 Trans IL], "CFC R12 Trans", [CFC R12 Trans IL], "NFC R12 Trans", [NFC R12 Trans IL] ) // List of measures to switch between, the list includes COMPARISON measures on Transaction currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Comp (XR1 Period Based) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected Comparison XR1 (Period Based) Measure], "ACT PY XR1 (Period Based)", [ACT PY XR1 (Period Based) IL], "BUD XR1 (Period Based)", [BUD XR1 (Period Based) IL], "CFC XR1 (Period Based)", [CFC XR1 (Period Based) IL], "NFC XR1 (Period Based)", [NFC XR1 (Period Based) IL], "ACT PY YTD XR1 (Period Based)", [ACT PY YTD XR1 (Period Based) IL], "BUD YTD XR1 (Period Based)", [BUD YTD XR1 (Period Based) IL], "CFC YTD XR1 (Period Based)", [CFC YTD XR1 (Period Based) IL], "NFC YTD XR1 (Period Based)", [NFC YTD XR1 (Period Based) IL], "ACT PY R12 XR1 (Period Based)", [ACT PY R12 XR1 (Period Based) IL], "BUD R12 XR1 (Period Based)", [BUD R12 XR1 (Period Based) IL], "CFC R12 XR1 (Period Based)", [CFC R12 XR1 (Period Based) IL], "NFC R12 XR1 (Period Based)", [NFC R12 XR1 (Period Based) IL] ) // List of measures to switch between, the list includes COMPARISON measures on XR1 (Period Based) currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Comp (XR1 YTD Based) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected Comparison XR1 (YTD Based) Measure], "ACT PY XR1 (YTD Based)", [ACT PY XR1 (YTD Based) IL], "BUD XR1 (YTD Based)", [BUD XR1 (YTD Based) IL], "CFC XR1 (YTD Based)", [CFC XR1 (YTD Based) IL], "NFC XR1 (YTD Based)", [NFC XR1 (YTD Based) IL], "ACT PY YTD XR1 (YTD Based)", [ACT PY YTD XR1 (YTD Based) IL], "BUD YTD XR1 (YTD Based)", [BUD YTD XR1 (YTD Based) IL], "CFC YTD XR1 (YTD Based)", [CFC YTD XR1 (YTD Based) IL], "NFC YTD XR1 (YTD Based)", [NFC YTD XR1 (YTD Based) IL], "ACT PY R12 XR1 (YTD Based)", [ACT PY R12 XR1 (YTD Based) IL], "BUD R12 XR1 (YTD Based)", [BUD R12 XR1 (YTD Based) IL], "CFC R12 XR1 (YTD Based)", [CFC R12 XR1 (YTD Based) IL], "NFC R12 XR1 (YTD Based)", [NFC R12 XR1 (YTD Based) IL] ) // List of measures to switch between, the list includes COMPARISON measures on XR1 (YTD Based) currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Comp (XR2 Period Based) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected Comparison XR2 (Period Based) Measure], "ACT PY XR2 (Period Based)", [ACT PY XR2 (Period Based) IL], "BUD XR2 (Period Based)", [BUD XR2 (Period Based) IL], "CFC XR2 (Period Based)", [CFC XR2 (Period Based) IL], "NFC XR2 (Period Based)", [NFC XR2 (Period Based) IL], "ACT PY YTD XR2 (Period Based)", [ACT PY YTD XR2 (Period Based) IL], "BUD YTD XR2 (Period Based)", [BUD YTD XR2 (Period Based) IL], "CFC YTD XR2 (Period Based)", [CFC YTD XR2 (Period Based) IL], "NFC YTD XR2 (Period Based)", [NFC YTD XR2 (Period Based) IL], "ACT PY R12 XR2 (Period Based)", [ACT PY R12 XR2 (Period Based) IL], "BUD R12 XR2 (Period Based)", [BUD R12 XR2 (Period Based) IL], "CFC R12 XR2 (Period Based)", [CFC R12 XR2 (Period Based) IL], "NFC R12 XR2 (Period Based)", [NFC R12 XR2 (Period Based) IL] ) // List of measures to switch between, the list includes COMPARISON measures on XR2 (Period Based) currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Comp (XR2 YTD Based) IL	Y	N	IL version of same GL measure		N	[Selected DisplayUnit Switch] * SWITCH([Selected Comparison XR2 (YTD Based) Measure], "ACT PY XR2 (YTD Based)", [ACT PY XR2 (YTD Based) IL], "BUD XR2 (YTD Based)", [BUD XR2 (YTD Based) IL], "CFC XR2 (YTD Based)", [CFC XR2 (YTD Based) IL], "NFC XR2 (YTD Based)", [NFC XR2 (YTD Based) IL], "ACT PY YTD XR2 (YTD Based)", [ACT PY YTD XR2 (YTD Based) IL], "BUD YTD XR2 (YTD Based)", [BUD YTD XR2 (YTD Based) IL], "CFC YTD XR2 (YTD Based)", [CFC YTD XR2 (YTD Based) IL], "NFC YTD XR2 (YTD Based)", [NFC YTD XR2 (YTD Based) IL], "ACT PY R12 XR2 (YTD Based)", [ACT PY R12 XR2 (YTD Based) IL], "BUD R12 XR2 (YTD Based)", [BUD R12 XR2 (YTD Based) IL], "CFC R12 XR2 (YTD Based)", [CFC R12 XR2 (YTD Based) IL], "NFC R12 XR2 (YTD Based)", [NFC R12 XR2 (YTD Based) IL] ) // List of measures to switch between, the list includes COMPARISON measures on XR2 (YTD Based) currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (Acc Currency) IL	Y	N	IL version of same GL measure		N	[Switch Actual (Acc Currency) IL] - [Switch Comp (Acc Currency) IL] // Calculates the difference between the SWITCH ACTUAL IL and the SWITCH COMPARISON IL measures specifically designed for Accounting Currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (Acc Currency%) IL	Y	N	IL version of same GL measure		N	DIVIDE([Switch Diff (Acc Currency) IL],ABS([Switch Comp (Acc Currency) IL]), Blank()) // Calculates the % difference between the SWITCH ACTUAL IL and the SWITCH COMPARISON IL measures specifically designed for Accounting Currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (Trans Currency) IL	Y	N	IL version of same GL measure		N	[Switch Actual (Trans Currency) IL] - [Switch Comp (Trans Currency) IL] // Calculates the difference between the SWITCH ACTUAL and the SWITCH COMPARISON measures specifically designed for Transaction Currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (Trans Currency%) IL	Y	N	IL version of same GL measure		N	DIVIDE([Switch Diff (Trans Currency) IL],ABS([Switch Comp (Trans Currency) IL]), Blank()) // Calculates the % difference between the SWITCH ACTUAL and the SWITCH COMPARISON measures specifically designed for Transaction Currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (XR1 Period Based) IL	Y	N	IL version of same GL measure		N	[Switch Actual (XR1 Period Based) IL] - [Switch Comp (XR1 Period Based) IL] // Calculates the difference between the SWITCH ACTUAL and the SWITCH COMPARISON measures specifically designed for XR1 Period Based Currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (XR1 Period Based%) IL	Y	N	IL version of same GL measure		N	DIVIDE([Switch Diff (XR1 Period Based) IL],ABS([Switch Comp (XR1 Period Based) IL]), Blank()) // Calculates the % difference between the SWITCH ACTUAL and the SWITCH COMPARISON measures specifically designed for XR1 Period Based Currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (XR1 YTD Based) IL	Y	N	IL version of same GL measure		N	[Switch Actual (XR1 YTD Based) IL] - [Switch Comp (XR1 YTD Based) IL] // Calculates the difference between the SWITCH ACTUAL and the SWITCH COMPARISON measures specifically designed for XR1 YTD Based Currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (XR1 YTD Based%) IL	Y	N	IL version of same GL measure		N	DIVIDE([Switch Diff (XR1 YTD Based) IL],ABS([Switch Comp (XR1 YTD Based) IL]), Blank()) // Calculates the % difference between the SWITCH ACTUAL and the SWITCH COMPARISON measures specifically designed for XR1 YTD Based Currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (XR2 Period Based) IL	Y	N	IL version of same GL measure		N	[Switch Actual (XR2 Period Based) IL] - [Switch Comp (XR2 Period Based) IL] // Calculates the difference between the SWITCH ACTUAL and the SWITCH COMPARISON measures specifically designed for XR2 Period Based Currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (XR2 Period Based%) IL	Y	N	IL version of same GL measure		N	DIVIDE([Switch Diff (XR2 Period Based) IL],ABS([Switch Comp (XR2 Period Based) IL]), Blank()) // Calculates the % difference between the SWITCH ACTUAL and the SWITCH COMPARISON measures specifically designed for XR2 Period Based Currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (XR2 YTD Based) IL	Y	N	IL version of same GL measure		N	[Switch Actual (XR2 YTD Based) IL] - [Switch Comp (XR2 YTD Based) IL] // Calculates the difference between the SWITCH ACTUAL and the SWITCH COMPARISON measures specifically designed for XR2 YTD Based Currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.
Switch Diff (XR2 YTD Based%) IL	Y	N	IL version of same GL measure		N	DIVIDE([Switch Diff (XR2 YTD Based) IL],ABS([Switch Comp (XR2 YTD Based) IL]), Blank()) // Calculates the % difference between the SWITCH ACTUAL and the SWITCH COMPARISON measures specifically designed for XR2 YTD Based Currency. // Mandatory to filter a single value from tables SWITCH COMPARISON MEASURE and SWITCH TIME PERSPECTIVE for this measure to function.

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

General Ledger

Data source Information

The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.

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

Model Table	BI Access View	Referenced Information Source	Recommended Access Type
IL ANALYSIS MEASURES	FACT_IL_ANALYSIS_PQ_BI	FACT_INTERNAL_LEDGER_ANALYSIS	On Line