On this page you will find the specifications regarding the Model: Revenue Recognition and Fact Table: GENERAL LEDGER MEASURES.
| Attribute | Description (where applicable) |
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:
| Measure | Calculated Y/N | Contains Time Intelligence Y/N | Definition/Note (where applicable) | Aggregation Type | Hidden Y/N | Measure Expression |
| Actual Cost (Actual) | Y | N | Cumulative Actual Cost, ACTUAL, Accounting currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[ACTUAL_COSTS]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Actual Cost, ACTUAL, Accounting currency, General Ledger. |
| Adjusted Recognized Cost (Actual) | Y | N | Cumulative Adjusted Cost, ACTUAL, Accounting currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[ADJUSTED_RECOG_COST]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Adjusted Cost, ACTUAL, Accounting currency, General Ledger. |
| Calculated Cost (Actual) | Y | N | Cumulative Calculated Cost, ACTUAL, Accounting currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[CALCULATED_COSTS]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Calculated Cost, ACTUAL, Accounting currency, General Ledger. |
| Completed Cost (Actual) | Y | N | Cumulative Completed Cost, ACTUAL, Accounting currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[COMPLETED_COST]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Completed Cost, ACTUAL, Accounting currency, General Ledger. |
| Estimated Cost (Actual) | Y | N | Cumulative Estimated Cost, ACTUAL, Accounting currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[EST_COSTS]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Estimated Cost, ACTUAL, Accounting currency, General Ledger. |
| Excluded Cost (Actual) | Y | N | Cumulative Excluded Cost, ACTUAL, Accounting currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[EXCLUDED_COST]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Excluded Cost, ACTUAL, Accounting currency, General Ledger. |
| Recog Cost (Actual) | Y | N | Recognized Cost, ACTUAL, Accounting Currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[COST_RECOG_CURRENT]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The period amount for each reporting period with available ACTUAL figures. // Amount = Recognized Cost, ACTUAL, Accounting Currency, General Ledger. |
| Total Cost (Actual) | Y | N | Cumulative Total Cost, ACTUAL, Accounting currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[TOTAL_COST]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Total Cost, ACTUAL, Accounting currency, General Ledger. |
| Estimated Income (Actual) | Y | N | Cumulative Estimated Income, ACTUAL, Accounting currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[EST_INCOME]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Estimated Income, ACTUAL, Accounting currency, General Ledger. |
| Recog Income (Actual) | Y | N | Recognized Income, ACTUAL, Accounting Currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[INCOME_CURR]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The period amount for each reporting period with available ACTUAL figures. // Amount = Recognized Income, ACTUAL, Accounting Currency, General Ledger. |
| Percentage of Completion (Actual) | Y | N | Cumulative Percentage of completion (Actual) up until the selected period. | SUM | N | IF(HASONEVALUE('ACCOUNTING PROJECT'[Accounting Project Code]), CALCULATE( SUM('FACT ACTUAL AMOUNTS'[POC_CURRENT]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) )/100 , BLANK()) // Cumulative Percentage of completion up until the selected period. // NOTE: This measure can only be presented for a single project, so not possible to sum up %-values for multiple projects. |
| Actual Revenue (Actual) | Y | N | Actual Revenue, ACTUAL, Accounting Currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[ACTUAL_REVENUE]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Actual Revenue, ACTUAL, Accounting currency, General Ledger. |
| Adjusted Recognized Revenue (Actual) | Y | N | Cumulative Adjusted Revenue, ACTUAL, Accounting currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[ADJUSTED_RECOG_REVENUE]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Adjusted Revenue, ACTUAL, Accounting currency, General Ledger. |
| Calculated Revenue (Actual) | Y | N | Cumulative Calculated Revenue, ACTUAL, Accounting currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[CALCULATED_REVENUE]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Calculated Revenue, ACTUAL, Accounting currency, General Ledger. |
| Completed Revenue (Actual) | Y | N | Cumulative Completed Revenue, ACTUAL, Accounting currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[COMPLETED_REVENUE]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Completed Revenue, ACTUAL, Accounting currency, General Ledger. |
| Estimated Revenue (Actual) | Y | N | Cumulative Estimated Revenue, ACTUAL, Accounting currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[EST_REVENUE]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Estimated Revenue, ACTUAL, Accounting currency, General Ledger. |
| Excluded Revenue (Actual) | Y | N | Cumulative Excluded Revenue, ACTUAL, Accounting currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[EXCLUDED_REVENUE]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Excluded Revenue, ACTUAL, Accounting currency, General Ledger. |
| Recog Revenue (Actual) | Y | N | Recognized Revenue, ACTUAL, Accounting Currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[REVENUE_RECOG_CURR]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The period amount for each reporting period with available ACTUAL figures. // Amount = Recognized Revenue, ACTUAL, Accounting Currency, General Ledger. |
| Total Revenue (Actual) | Y | N | Cumulative Total Revenue, ACTUAL, Accounting currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[TOTAL_REVENUE]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "00" || 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] = "*" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Total Revenue, ACTUAL, Accounting currency, General Ledger. |
| Recog Margin (Actual) | Y | N | Margin(%) = Recognized Income / Recognized Revenue, ACTUAL, Accounting Currency, General Ledger. | DIVIDE | N | DIVIDE([Recog Income (Actual)], [Recog Revenue (Actual)]) // The period margin(%) for each reporting period with available ACTUAL figures. // Margin(%) = Recognized Income / Recognized Revenue, ACTUAL, Accounting Currency, General Ledger. |
| Estimated Margin (Actual) | Y | N | Cumulative Estimated Margin, ACTUAL, Accounting currency, General Ledger. | DIVIDE | N | DIVIDE([Estimated Income (Actual)], [Estimated Revenue (Actual)]) // Cumulative Estimated Margin, ACTUAL, Accounting currency, General Ledger. // Estimated Margin(%) calculated as Estimated Income / Estimated Revenue. |
| Recog Revenue (Forecast) | Y | N | Recognized Revenue, FORECAST, Accounting Currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT FORECAST AMOUNTS'[RECOG_REVENUE_PERIOD]), FILTER( 'FORECAST VERSION', 'FORECAST VERSION'[Ledger ID] = "00" || 'FORECAST VERSION'[Ledger ID] = "*" ) ) // The period amount for each reporting period with available FORECAST figures. // Amount = Recognized Revenue, FORECAST, Accounting Currency, General Ledger. // NOTE: Need to filter on one and only one Cut-Off Period to be able to calculate amount for a single forecast ID |
| Recog Cost (Forecast) | Y | N | Recognized Cost, FORECAST, Accounting Currency, General Ledger. | SUM | N | CALCULATE( SUM('FACT FORECAST AMOUNTS'[RECOG_COST_PERIOD]), FILTER( 'FORECAST VERSION', 'FORECAST VERSION'[Ledger ID] = "00" || 'FORECAST VERSION'[Ledger ID] = "*" ) ) // The period amount for each reporting period with available FORECAST figures. // Amount = Recognized Cost, FORECAST, Accounting Currency, General Ledger. // NOTE: Need to filter on one and only one Cut-Off Period to be able to calculate amount for a single forecast ID. |
| Cumulative Recog Cost (Actual) | Y | Y | Cumulative Recognized Cost, ACTUAL, Accounting currency, General Ledger. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], CALCULATE([Recog Cost (Actual)], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Recognized Cost, ACTUAL, Accounting currency, General Ledger. // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available ACTUAL amounts. |
| Cumulative Recog Cost (Forecast) | Y | Y | Cumulative Recognized Cost, mix of ACTUAL and FORECAST, Accounting currency, General Ledger. | SUM | N | VAR MaxDate = MAX('REPORTING PERIOD'[ID]) RETURN CALCULATE([Recog Cost (Actual)], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] && 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )) + CALCULATE([Recog Cost (Forecast)], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MaxDate )) // The cumulative amount. ACTUAL figures up to the selected Cut-Off Period, followed by including FORECAST figures beyond the selected Cut-Off Period. // Amount = Cumulative Recognized Cost, mix of ACTUAL and FORECAST, Accounting currency, General Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Recog Cost (Mixed) | Y | Y | Recognized Cost, ACTUAL or FORECAST, Accounting Currency, General Ledger. | SUM | N | CALCULATE([Recog Cost (Actual)], FILTER( 'REPORTING PERIOD', 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] )) + [Recog Cost (Forecast)] // The period amount for each reporting period with available ACTUAL or FORECAST figures. // ACTUAL figures up to the selected Cut-Off Period, followed by FORECAST figures beyond the selected Cut-Off Period. // Amount = Recognized Cost, ACTUAL or FORECAST, Accounting Currency, General Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Cumulative Recog Margin (Actual) | Y | Y | Margin(%) = Cumulative Recognized Income / Cumulative Recognized Revenue, ACTUAL, Accounting currency, General Ledger. | DIVIDE | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], CALCULATE(DIVIDE([Cumulative Recog Income (Actual)], [Cumulative Recog Revenue (Actual)]), FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative margin(%) for reporting periods with available ACTUAL figures. // Margin(%) = Cumulative Recognized Income / Cumulative Recognized Revenue, ACTUAL, Accounting currency, General Ledger. // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available ACTUAL amounts. |
| Recog Revenue (Mixed) | Y | Y | Recognized Revenue, ACTUAL or FORECAST, Accounting Currency, General Ledger. | SUM | N | CALCULATE([Recog Revenue (Actual)], FILTER( 'REPORTING PERIOD', 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] )) + [Recog Revenue (Forecast)] // The period amount for each reporting period with available ACTUAL or FORECAST figures. // ACTUAL figures up to the selected Cut-Off Period, followed by FORECAST figures beyond the selected Cut-Off Period. // Amount = Recognized Revenue, ACTUAL or FORECAST, Accounting Currency, General Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Cumulative Recog Income (Actual) | Y | Y | Cumulative Recognized Income, ACTUAL, Accounting currency, General Ledger. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], CALCULATE([Recog Income (Actual)], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Recognized Income, ACTUAL, Accounting currency, General Ledger. // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available actual amounts. |
| Cumulative Recog Revenue (Forecast) | Y | Y | Cumulative Recognized Revenue, mix of ACTUAL and FORECAST, Accounting currency, General Ledger. | SUM | N | VAR MaxDate = MAX('REPORTING PERIOD'[ID]) RETURN CALCULATE([Recog Revenue (Actual)], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] && 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )) + CALCULATE([Recog Revenue (Forecast)], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MaxDate )) // The cumulative amount. ACTUAL figures up to the selected Cut-Off Period, followed by including FORECAST figures beyond the selected Cut-Off Period. // Amount = Cumulative Recognized Revenue, mix of ACTUAL and FORECAST, Accounting currency, General Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Cumulative Recog Revenue (Actual) | Y | Y | Cumulative Recognized Revenue, ACTUAL, Accounting currency, General Ledger. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], CALCULATE([Recog Revenue (Actual)], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Recognized Revenue, ACTUAL, Accounting currency, General Ledger. // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available ACTUAL amounts. |
| Recog Income (Forecast) | Y | N | Recognized Income, FORECAST, Accounting Currency, General Ledger. | SUM | N | [Recog Revenue (Forecast)] - [Recog Cost (Forecast)] // The period amount for each reporting period with available FORECAST figures. // Amount = Recognized Income, FORECAST, Accounting Currency, General Ledger. // NOTE: Need to filter on one and only one Cut-Off Period to be able to calculate amount for a single forecast ID |
| Recog Margin (Forecast) | Y | N | Margin(%) = Recognized Income / Recognized Revenue, FORECAST, Accounting Currency, General Ledger. | DIVIDE | N | DIVIDE([Recog Income (Forecast)], [Recog Revenue (Forecast)]) // The period margin(%) for each reporting period with available FORECAST figures. // Margin(%) = Recognized Income / Recognized Revenue, FORECAST, Accounting Currency, General Ledger. |
| Recog Margin (Mixed) | Y | Y | Margin(%) = Recognized Income / Recognized Revenue, mix of ACTUAL and FORECAST, Accounting currency, General Ledger. | DIVIDE | N | DIVIDE([Recog Income (Mixed)], [Recog Revenue (Mixed)]) // The margin(%) by reporting period. Only ACTUAL figures up to the selected Cut-Off Period, followed by using FORECAST figures beyond the selected Cut-Off Period. // Margin(%) = Recognized Income / Recognized Revenue, mix of ACTUAL and FORECAST, Accounting currency, General Ledger. |
| Recog Income (Mixed) | Y | Y | Recognized Income, ACTUAL or FORECAST, Accounting Currency, General Ledger. | SUM | N | CALCULATE([Recog Income (Actual)], FILTER( 'REPORTING PERIOD', 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] )) + [Recog Income (Forecast)] // The period amount for each reporting period with available ACTUAL or FORECAST figures. // ACTUAL figures up to the selected Cut-Off Period, followed by FORECAST figures beyond the selected Cut-Off Period. // Amount = Recognized Income, ACTUAL or FORECAST, Accounting Currency, General Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Cumulative Recog Income (Forecast) | Y | Y | Cumulative Recognized Income, mix of ACTUAL and FORECAST, Accounting currency, General Ledger. | SUM | N | VAR MaxDate = MAX('REPORTING PERIOD'[ID]) RETURN CALCULATE([Recog Income (Actual)], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] && 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )) + CALCULATE([Recog Income (Forecast)], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MaxDate )) // The cumulative amount. ACTUAL figures up to the selected Cut-Off Period, followed by including FORECAST figures beyond the selected Cut-Off Period. // Amount = Cumulative Recognized Income, mix of ACTUAL and FORECAST, Accounting currency, General Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Cumulative Recog Margin (Forecast) | Y | Y | Margin(%) = Cumulative Recognized Income / Cumulative Recognized Revenue, mix of ACTUAL and FORECAST, Accounting currency, General Ledger. | DIVIDE | N | VAR MaxDate = MAX('REPORTING PERIOD'[ID]) RETURN CALCULATE(DIVIDE([Cumulative Recog Income (Forecast)], [Cumulative Recog Revenue (Forecast)]), FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MaxDate )) // The cumulative margin(%). Only ACTUAL figures up to the selected Cut-Off Period, followed by using FORECAST figures beyond the selected Cut-Off Period. // Margin(%) = Cumulative Recognized Income / Cumulative Recognized Revenue, mix of ACTUAL and FORECAST, Accounting currency, General Ledger. |
| Recog Cost (Actual) X-Rate | Y | N | Recognized Cost, ACTUAL, X-rate Currency, General Ledger. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Recog Cost (Actual)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available ACTUAL figures. // Amount = Recognized Cost, ACTUAL, X-rate Currency, General Ledger. |
| Recog Cost (Forecast) X-Rate | Y | N | Recognized Cost, FORECAST, X-rate Currency, General Ledger. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT FORECAST AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Recog Cost (Forecast)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available FORECAST figures. // Amount = Recognized Cost, FORECAST, X-rate Currency, General Ledger. // NOTE: Need to filter on one and only one Cut-Off Period to be able to calculate amount for a single forecast ID. |
| Recog Cost (Mixed) X-Rate | Y | Y | Recognized Cost, ACTUAL or FORECAST, X-rate Currency, General Ledger. | SUM | N | CALCULATE([Recog Cost (Actual) X-Rate], FILTER( 'REPORTING PERIOD', 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] )) + [Recog Cost (Forecast) X-Rate] // The period amount for each reporting period with available ACTUAL or FORECAST figures. // ACTUAL figures up to the selected Cut-Off Period, followed by FORECAST figures beyond the selected Cut-Off Period. // Amount = Recognized Cost, ACTUAL or FORECAST, X-rate Currency, General Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Cumulative Recog Cost (Actual) X-Rate | Y | Y | Cumulative Recognized Cost, ACTUAL, X-rate currency, General Ledger. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], CALCULATE([Recog Cost (Actual) X-Rate], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Recognized Cost, ACTUAL, X-rate currency, General Ledger. // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available ACTUAL amounts. |
| Cumulative Recog Cost (Forecast) X-Rate | Y | Y | Cumulative Recognized Cost, mix of ACTUAL and FORECAST, X-rate currency, General Ledger. | SUM | N | VAR MaxDate = MAX('REPORTING PERIOD'[ID]) RETURN CALCULATE([Recog Cost (Actual) X-Rate], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] && 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )) + CALCULATE([Recog Cost (Forecast) X-Rate], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MaxDate )) // The cumulative amount. ACTUAL figures up to the selected Cut-Off Period, followed by including FORECAST figures beyond the selected Cut-Off Period. // Amount = Cumulative Recognized Cost, mix of ACTUAL and FORECAST, X-rate currency, General Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Diff Recog Revenue (Act vs Fc) | Y | N | The difference between ACTUAL amount minus FORECAST amount in each period. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Revenue (Actual)]) || ISBLANK([Recog Revenue (Forecast)]), BLANK(), [Recog Revenue (Actual)] - [Recog Revenue (Forecast)] ) ) // The difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Revenue, ACTUAL minus FORECAST, Accounting currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Cumulative Recog Revenue (Act vs Fc) | Y | N | The difference between ACTUAL amount minus FORECAST amount in each period. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Revenue (Actual)]) || ISBLANK([Recog Revenue (Forecast)]), BLANK(), [Cumulative Recog Revenue (Actual)] - [Cumulative Recog Revenue (Forecast)] ) ) // The difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Revenue, ACTUAL minus FORECAST, Accounting currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Recog Cost (Act vs Fc) | Y | N | The difference between ACTUAL amount minus FORECAST amount in each period. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Cost (Actual)]) || ISBLANK([Recog Cost (Forecast)]), BLANK(), [Recog Cost (Actual)] - [Recog Cost (Forecast)] ) ) // The difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Cost, ACTUAL minus FORECAST, Accounting currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Recog Revenue (Act vs Fc) | Y | N | The % difference between ACTUAL amount minus FORECAST amount in each period. | DIVIDE | N | DIVIDE([Diff Recog Revenue (Act vs Fc)],ABS([Recog Revenue (Forecast)]), Blank()) // The %-difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Revenue, ACTUAL minus FORECAST, Accounting currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Recog Cost (Act vs Fc) | Y | N | The % difference between ACTUAL amount minus FORECAST amount in each period. | DIVIDE | N | DIVIDE([Diff Recog Cost (Act vs Fc)],ABS([Recog Cost (Forecast)]), Blank()) // The %-difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Cost, ACTUAL minus FORECAST, Accounting currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Cumulative Recog Revenue (Act vs Fc) | Y | N | The % difference between ACTUAL amount minus FORECAST amount in each period. | DIVIDE | N | DIVIDE([Diff Cumulative Recog Revenue (Act vs Fc)],ABS([Cumulative Recog Revenue (Forecast)]), Blank()) // The %-difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Revenue, ACTUAL vs FORECAST, Accounting currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Cumulative Recog Cost (Act vs Fc) | Y | N | The difference between ACTUAL amount minus FORECAST amount in each period. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Cost (Actual)]) || ISBLANK([Recog Cost (Forecast)]), BLANK(), [Cumulative Recog Cost (Actual)] - [Cumulative Recog Cost (Forecast)] ) ) // The difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Cost, ACTUAL minus FORECAST, Accounting currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Cumulative Recog Cost (Act vs Fc) | Y | N | The % difference between ACTUAL amount minus FORECAST amount in each period. | DIVIDE | N | DIVIDE([Diff Cumulative Recog Cost (Act vs Fc)],ABS([Cumulative Recog Cost (Forecast)]), Blank()) // The %-difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Cost, ACTUAL vs FORECAST, Accounting currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Recog Income (Act vs Fc) | Y | N | The difference between ACTUAL amount minus FORECAST amount in each period. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Income (Actual)]) || ISBLANK([Recog Income (Forecast)]), BLANK(), [Recog Income (Actual)] - [Recog Income (Forecast)] ) ) // The difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Income, ACTUAL minus FORECAST, Accounting currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Recog Income (Act vs Fc) | Y | N | The % difference between ACTUAL amount minus FORECAST amount in each period. | DIVIDE | N | DIVIDE([Diff Recog Income (Act vs Fc)],ABS([Recog Income (Forecast)]), Blank()) // The %-difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Income, ACTUAL minus FORECAST, Accounting currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Cumulative Recog Income (Act vs Fc) | Y | N | The difference between ACTUAL amount minus FORECAST amount in each period. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Income (Actual)]) || ISBLANK([Recog Income (Forecast)]), BLANK(), [Cumulative Recog Income (Actual)] - [Cumulative Recog Income (Forecast)] ) ) // The difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Income, ACTUAL minus FORECAST, Accounting currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Cumulative Recog Income (Act vs Fc) | Y | N | The % difference between ACTUAL amount minus FORECAST amount in each period. | DIVIDE | N | DIVIDE([Diff Cumulative Recog Income (Act vs Fc)],ABS([Cumulative Recog Income (Forecast)]), Blank()) // The %-difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Income, ACTUAL vs FORECAST, Accounting currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Recog Cost (Act vs Fc) X-Rate | Y | N | The difference between ACTUAL amount minus FORECAST amount in each period. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Cost (Actual)]) || ISBLANK([Recog Cost (Forecast)]), BLANK(), [Recog Cost (Actual) X-Rate] - [Recog Cost (Forecast) X-Rate] ) ) // The difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Cost, ACTUAL minus FORECAST, X-rate currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Recog Cost (Act vs Fc) X-Rate | Y | N | The % difference between ACTUAL amount minus FORECAST amount in each period. | DIVIDE | N | DIVIDE([Diff Recog Cost (Act vs Fc) X-Rate],ABS([Recog Cost (Forecast) X-Rate]), Blank()) // The %-difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Cost, ACTUAL minus FORECAST, X-rate currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Cumulative Recog Cost (Act vs Fc) X-Rate | Y | N | The difference between ACTUAL amount minus FORECAST amount in each period. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Cost (Actual)]) || ISBLANK([Recog Cost (Forecast)]), BLANK(), [Cumulative Recog Cost (Actual) X-Rate] - [Cumulative Recog Cost (Forecast) X-Rate] ) ) // The difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Cost, ACTUAL minus FORECAST, X-rate currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Cumulative Recog Cost (Act vs Fc) X-Rate | Y | N | The % difference between ACTUAL amount minus FORECAST amount in each period. | DIVIDE | N | DIVIDE([Diff Cumulative Recog Cost (Act vs Fc) X-Rate],ABS([Cumulative Recog Cost (Forecast) X-Rate]), Blank()) // The %-difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Cost, ACTUAL vs FORECAST, X-rate currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Recog Revenue (Actual) X-Rate | Y | N | Recognized Revenue, ACTUAL, Accounting Currency, General Ledger. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Recog Revenue (Actual)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available ACTUAL figures. // Amount = Recognized Revenue, ACTUAL, X-rate Currency, General Ledger. |
| Recog Revenue (Forecast) X-Rate | Y | N | Recognized Revenue, FORECAST, Accounting Currency, General Ledger. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT FORECAST AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Recog Revenue (Forecast)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available FORECAST figures. // Amount = Recognized Revenue, FORECAST, X-rate Currency, General Ledger. // NOTE: Need to filter on one and only one Cut-Off Period to be able to calculate amount for a single forecast ID |
| Recog Revenue (Mixed) X-Rate | Y | Y | Recognized Revenue, ACTUAL or FORECAST, Accounting Currency, General Ledger. | SUM | N | CALCULATE([Recog Revenue (Actual) X-Rate], FILTER( 'REPORTING PERIOD', 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] )) + [Recog Revenue (Forecast) X-Rate] // The period amount for each reporting period with available ACTUAL or FORECAST figures. // ACTUAL figures up to the selected Cut-Off Period, followed by FORECAST figures beyond the selected Cut-Off Period. // Amount = Recognized Revenue, ACTUAL or FORECAST, X-rate Currency, General Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Diff Recog Revenue (Act vs Fc) X-Rate | Y | N | The difference between ACTUAL amount minus FORECAST amount in each period. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Revenue (Actual)]) || ISBLANK([Recog Revenue (Forecast)]), BLANK(), [Recog Revenue (Actual) X-Rate] - [Recog Revenue (Forecast) X-Rate] ) ) // The difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Revenue, ACTUAL minus FORECAST, Accounting currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Recog Revenue (Act vs Fc) X-Rate | Y | N | The % difference between ACTUAL amount minus FORECAST amount in each period. | DIVIDE | N | DIVIDE([Diff Recog Revenue (Act vs Fc) X-Rate],ABS([Recog Revenue (Forecast) X-Rate]), Blank()) // The %-difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Revenue, ACTUAL minus FORECAST, X-rate currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Cumulative Recog Revenue (Actual) X-Rate | Y | Y | Cumulative Recognized Revenue, ACTUAL, X-rate currency, General Ledger. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], CALCULATE([Recog Revenue (Actual) X-Rate], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Recognized Revenue, ACTUAL, X-rate currency, General Ledger. // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available ACTUAL amounts. |
| Cumulative Recog Revenue (Forecast) X-Rate | Y | Y | Cumulative Recognized Revenue, mix of ACTUAL and FORECAST, X-rate currency, General Ledger. | SUM | N | VAR MaxDate = MAX('REPORTING PERIOD'[ID]) RETURN CALCULATE([Recog Revenue (Actual) X-Rate], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] && 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )) + CALCULATE([Recog Revenue (Forecast) X-Rate], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MaxDate )) // The cumulative amount. ACTUAL figures up to the selected Cut-Off Period, followed by including FORECAST figures beyond the selected Cut-Off Period. // Amount = Cumulative Recognized Revenue, mix of ACTUAL and FORECAST, X-rate currency, General Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Diff Cumulative Recog Revenue (Act vs Fc) X-Rate | Y | N | The difference between ACTUAL amount minus FORECAST amount in each period. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Revenue (Actual)]) || ISBLANK([Recog Revenue (Forecast)]), BLANK(), [Cumulative Recog Revenue (Actual) X-Rate] - [Cumulative Recog Revenue (Forecast) X-Rate] ) ) // The difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Revenue, ACTUAL minus FORECAST, X-rate currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Cumulative Recog Revenue (Act vs Fc) X-Rate | Y | N | The % difference between ACTUAL amount minus FORECAST amount in each period. | DIVIDE | N | DIVIDE([Diff Cumulative Recog Revenue (Act vs Fc) X-Rate],ABS([Cumulative Recog Revenue (Forecast) X-Rate]), Blank()) // The %-difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Revenue, ACTUAL vs FORECAST, X-rate currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Recog Income (Actual) X-Rate | Y | N | Recognized Income, ACTUAL, X-rate Currency, General Ledger. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Recog Income (Actual)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available ACTUAL figures. // Amount = Recognized Income, ACTUAL, X-rate Currency, General Ledger. |
| Recog Income (Forecast) X-Rate | Y | N | Recognized Income, FORECAST, X-rate Currency, General Ledger. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT FORECAST AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Recog Income (Forecast)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available FORECAST figures. // Amount = Recognized Income, FORECAST, X-rate Currency, General Ledger. // NOTE: Need to filter on one and only one Cut-Off Period to be able to calculate amount for a single forecast ID |
| Recog Income (Mixed) X-Rate | Y | Y | Recognized Income, ACTUAL or FORECAST, X-rate Currency, General Ledger. | SUM | N | CALCULATE([Recog Income (Actual) X-Rate], FILTER( 'REPORTING PERIOD', 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] )) + [Recog Income (Forecast) X-Rate] // The period amount for each reporting period with available ACTUAL or FORECAST figures. // ACTUAL figures up to the selected Cut-Off Period, followed by FORECAST figures beyond the selected Cut-Off Period. // Amount = Recognized Income, ACTUAL or FORECAST, X-rate Currency, General Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Diff Recog Income (Act vs Fc) X-Rate | Y | N | The difference between ACTUAL amount minus FORECAST amount in each period. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Income (Actual)]) || ISBLANK([Recog Income (Forecast)]), BLANK(), [Recog Income (Actual) X-Rate] - [Recog Income (Forecast) X-Rate] ) ) // The difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Income, ACTUAL minus FORECAST, X-rate currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Recog Income (Act vs Fc) X-Rate | Y | N | The % difference between ACTUAL amount minus FORECAST amount in each period. | DIVIDE | N | DIVIDE([Diff Recog Income (Act vs Fc) X-Rate],ABS([Recog Income (Forecast) X-Rate]), Blank()) // The %-difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Income, ACTUAL minus FORECAST, X-rate currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Cumulative Recog Income (Actual) X-Rate | Y | Y | Cumulative Recognized Revenue, ACTUAL, X-rate currency, General Ledger. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], CALCULATE([Recog Income (Actual) X-Rate], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Recognized Income, ACTUAL, X-rate currency, General Ledger. // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available actual amounts. |
| Cumulative Recog Income (Forecast) X-Rate | Y | Y | Cumulative Recognized Revenue, mix of ACTUAL and FORECAST, X-rate currency, General Ledger. | SUM | N | VAR MaxDate = MAX('REPORTING PERIOD'[ID]) RETURN CALCULATE([Recog Income (Actual) X-Rate], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] && 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )) + CALCULATE([Recog Income (Forecast) X-Rate], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MaxDate )) // The cumulative amount. ACTUAL figures up to the selected Cut-Off Period, followed by including FORECAST figures beyond the selected Cut-Off Period. // Amount = Cumulative Recognized Income, mix of ACTUAL and FORECAST, X-rate currency, General Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Diff Cumulative Recog Income (Act vs Fc) X-Rate | Y | N | The % difference between ACTUAL amount minus FORECAST amount in each period. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Income (Actual)]) || ISBLANK([Recog Income (Forecast)]), BLANK(), [Cumulative Recog Income (Actual) X-Rate] - [Cumulative Recog Income (Forecast) X-Rate] ) ) // The difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Income, ACTUAL minus FORECAST, X-rate currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Cumulative Recog Income (Act vs Fc) X-Rate | Y | N | The % difference between ACTUAL amount minus FORECAST amount in each period. | DIVIDE | N | DIVIDE([Diff Cumulative Recog Income (Act vs Fc) X-Rate],ABS([Cumulative Recog Income (Forecast) X-Rate]), Blank()) // The %-difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Income, ACTUAL vs FORECAST, X-rate currency, General Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Recog Margin (Actual) X-Rate | Y | N | Margin(%) = Recognized Income / Recognized Revenue, ACTUAL, X-rate Currency, General Ledger. | DIVIDE | N | DIVIDE([Recog Income (Actual) X-Rate], [Recog Revenue (Actual) X-Rate]) // The period margin(%) for each reporting period with available ACTUAL figures. // Margin(%) = Recognized Income / Recognized Revenue, ACTUAL, X-rate Currency, General Ledger. |
| Recog Margin (Forecast) X-Rate | Y | N | Margin(%) = Recognized Income / Recognized Revenue, FORECAST, X-rate Currency, General Ledger. | DIVIDE | N | DIVIDE([Recog Income (Forecast) X-Rate], [Recog Revenue (Forecast) X-Rate]) // The period margin(%) for each reporting period with available FORECAST figures. // Margin(%) = Recognized Income / Recognized Revenue, FORECAST, X-rate Currency, General Ledger. |
| Recog Margin (Mixed) X-Rate | Y | Y | Margin(%) = Recognized Income / Recognized Revenue, mix of ACTUAL and FORECAST, X-rate currency, General Ledger. | DIVIDE | N | DIVIDE([Recog Income (Mixed) X-Rate], [Recog Revenue (Mixed) X-Rate]) // The margin(%) by reporting period. Only ACTUAL figures up to the selected Cut-Off Period, followed by using FORECAST figures beyond the selected Cut-Off Period. // Margin(%) = Recognized Income / Recognized Revenue, mix of ACTUAL and FORECAST, X-rate currency, General Ledger. |
| Cumulative Recog Margin (Actual) X-Rate | Y | Y | Margin(%) = Cumulative Recognized Income / Cumulative Recognized Revenue, ACTUAL, X-rate currency, General Ledger. | DIVIDE | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], CALCULATE(DIVIDE([Cumulative Recog Income (Actual) X-Rate], [Cumulative Recog Revenue (Actual) X-Rate]), FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative margin(%) for reporting periods with available ACTUAL figures. // Margin(%) = Cumulative Recognized Income / Cumulative Recognized Revenue, ACTUAL, X-rate currency, General Ledger. // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available ACTUAL amounts. |
| Cumulative Recog Margin (Forecast) X-Rate | Y | Y | Margin(%) = Cumulative Recognized Income / Cumulative Recognized Revenue, mix of ACTUAL and FORECAST, X-rate currency, General Ledger. | DIVIDE | N | VAR MaxDate = MAX('REPORTING PERIOD'[ID]) RETURN CALCULATE(DIVIDE([Cumulative Recog Income (Forecast) X-Rate], [Cumulative Recog Revenue (Forecast) X-Rate]), FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MaxDate )) // The cumulative margin(%). Only ACTUAL figures up to the selected Cut-Off Period, followed by using FORECAST figures beyond the selected Cut-Off Period. // Margin(%) = Cumulative Recognized Income / Cumulative Recognized Revenue, mix of ACTUAL and FORECAST, X-rate currency, General Ledger. |
| Estimated Cost (Actual) X-Rate | Y | N | Cumulative Estimated Cost, ACTUAL, X-rate currency, General Ledger. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Estimated Cost (Actual)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Estimated Cost, ACTUAL, X-rate currency, General Ledger. |
| Estimated Income (Actual) X-Rate | Y | N | Cumulative Estimated Income, ACTUAL, X-rate currency, General Ledger. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Estimated Income (Actual)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Estimated Income, ACTUAL, X-rate currency, General Ledger. |
| Estimated Revenue (Actual) X-Rate | Y | N | Cumulative Estimated Revenue, ACTUAL, X-rate currency, General Ledger. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Estimated Revenue (Actual)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Estimated Revenue, ACTUAL, X-rate currency, General Ledger. |
| Estimated Margin (Actual) X-Rate | Y | N | Cumulative Estimated Margin, ACTUAL, X-rate currency, General Ledger. | DIVIDE | N | DIVIDE([Estimated Income (Actual) X-Rate], [Estimated Revenue (Actual) X-Rate]) // Cumulative Estimated Margin, ACTUAL, X-rate currency, General Ledger. // Estimated Margin(%) calculated as Estimated Income / Estimated Revenue. |
| Simulated Cost (Forecast) | Y | Y | Cumulative Total Cost and Simulated Cost, mix of ACTUAL and FORECAST, Accounting currency, General Ledger. TOTAL COST(Actual) to the selected Cut-Off Period, followed by SIMULATED COST(Forecast). | SUM | N | IF( SELECTEDVALUE('REPORTING PERIOD'[Reporting Year Period]) <= [SelectedCutOffPeriod], [Total Cost (Actual)], CALCULATE( SUM('FACT FORECAST AMOUNTS'[SIMULATED_COST]), FILTER( 'FORECAST VERSION', 'FORECAST VERSION'[Ledger ID] = "00" || 'FORECAST VERSION'[Ledger ID] = "*" ) )) // The cumulative Total cost and Simulated Cost. // TOTAL COST(Actual) up to the selected Cut-Off Period, followed by SIMULATED COST(Forecast) figures beyond the selected Cut-Off Period. // Amount = Cumulative Total Cost and Simulated Cost, mix of ACTUAL and FORECAST, Accounting currency, General Ledger. |
| Actual Income (Actual) | Y | N | Actual Income = Actual Revenue - Total Cost | SUM | N | [Actual Revenue (Actual)] - [Total Cost (Actual)] // Actual Income = Actual Revenue - Total Cost |
| Actual Margin (Actual) | Y | N | Margin(%) = Cumulative Actual Income / Cumulative Actual Revenue, ACTUAL, Accounting currency, General Ledger. NOTE: Actual Income = Actual Revenue - Total Cost | DIVIDE | N | DIVIDE([Actual Income (Actual)], [Actual Revenue (Actual)]) // The cumulative margin(%) for reporting periods with available ACTUAL figures. // Margin(%) = Cumulative Actual Income / Cumulative Actual Revenue, ACTUAL, Accounting currency, General Ledger. // NOTE: Actual Income = Actual Revenue - Total Cost // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available ACTUAL amounts. |
| Actual Revenue (Period Amount Calc) X-Rate | Y | Y | Actual Revenue, ACTUAL, X-rate Currency, General Ledger. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Actual Revenue (Period Amount Calc)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available ACTUAL figures. // Amount = Actual Revenue, ACTUAL, X-rate Currency, General Ledger. |
| Total Cost (Period Amount Calc) X-Rate | Y | Y | Total Cost, ACTUAL, X-rate Currency, General Ledger. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Total Cost (Period Amount Calc)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available ACTUAL figures. // Amount = Actual Cost, ACTUAL, X-rate Currency, General Ledger. |
| Actual Income (Period Amount Calc) X-Rate | Y | N | Actual Income, ACTUAL, X-rate Currency, General Ledger. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Actual Income (Period Amount Calc)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available ACTUAL figures. // Amount = Recognized Income, ACTUAL, X-rate Currency, General Ledger. |
| Actual Revenue (Actual) X-Rate | Y | N | Actual Revenue, ACTUAL, X-rate Currency, General Ledger. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], CALCULATE([Actual Revenue (Period Amount Calc) X-Rate], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Actual Revenue, ACTUAL, X-rate currency, General Ledger. |
| Total Cost (Actual) X-Rate | Y | N | Cumulative Total Cost, ACTUAL, X-rate currency, General Ledger. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], CALCULATE([Total Cost (Period Amount Calc) X-Rate], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Total Cost, ACTUAL, X-rate currency, General Ledger. |
| Actual Income (Actual) X-Rate | Y | N | Cumulative Actual Income, ACTUAL, X-rate currency, General Ledger. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], CALCULATE([Actual Income (Period Amount Calc) X-Rate], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Actual Income, ACTUAL, X-rate currency, General Ledger. |
| Actual Margin (Actual) X-Rate | Y | N | Margin(%) = Cumulative Actual Income / Cumulative Actual Revenue, ACTUAL, X-rate currency, General Ledger. | DIVIDE | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], CALCULATE(DIVIDE([Actual Income (Actual) X-Rate], [Actual Revenue (Actual) X-Rate]), FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative margin(%) for reporting periods with available ACTUAL figures. // Margin(%) = Cumulative Actual Income / Cumulative Actual Revenue, ACTUAL, X-rate currency, General Ledger. // NOTE: Actual Income = Actual Revenue - Total Cost // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available ACTUAL amounts. |
| Percentage of Completion (Period) (Forecast) | Y | N | Period value for Percentage of completion (Actual). | SUM | N | IF(HASONEVALUE('ACCOUNTING PROJECT'[Accounting Project Code]), CALCULATE( SUM('FACT FORECAST AMOUNTS'[POC_CURRENT]), FILTER( 'FORECAST VERSION', 'FORECAST VERSION'[Ledger ID] = "00" || 'FORECAST VERSION'[Ledger ID] = "*" ) )/100 , BLANK()) // Period value for Percentage of Completion (Forecast). // NOTE: This measure can only be presented for a single project, so not possible to sum up %-values for multiple projects. |
| Percentage of Completion (Forecast) | Y | N | Cumulative Percentage of completion (Forecast) up until the selected period. | SUM | N | VAR CutOffPeriod = [SelectedCutOffPeriod] VAR CurrentPeriod = SELECTEDVALUE('REPORTING PERIOD'[Reporting Year Period]) RETURN CALCULATE( [Percentage of Completion (Actual)], 'REPORTING PERIOD'[Reporting Year Period] <= CutOffPeriod ) + CALCULATE( [Percentage of Completion (Period) (Forecast)], ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) ) + IF( CurrentPeriod > CutOffPeriod, CALCULATE( [Percentage of Completion (Actual)], ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[Reporting Year Period] = CutOffPeriod ), BLANK() ) // Cumulative Percentage of Completion calculated as PoC (Actual) until cut off period thereafter adding cumulative PoC (Forecast) value in each period. |
| Percentage of Completion (Period) (Actual) | Y | N | Period value for Percentage of completion (Forecast). | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], [Percentage of Completion (Actual)] - CALCULATE([Percentage of Completion (Actual)], PREVIOUSMONTH('REPORTING PERIOD'[ID])), BLANK()) // Period value for Percentage of Completion (Actual) for each reporting period with available ACTUAL figures. // NOTE: This measure can only be presented for a single project, so not possible to sum up %-values for multiple projects. |
| Estimated Revenue (Forecast) | Y | N | Cumulative Estimated Revenue, ACTUAL or FORECAST, Accounting currency, General Ledger. | SUM | N | IF( SELECTEDVALUE('REPORTING PERIOD'[Reporting Year Period]) <= [SelectedCutOffPeriod], [Estimated Revenue (Actual)], CALCULATE( SUM('FACT FORECAST AMOUNTS'[ESTIMATED_REVENUE]), FILTER( 'FORECAST VERSION', 'FORECAST VERSION'[Ledger ID] = "00" || 'FORECAST VERSION'[Ledger ID] = "*" ) ) ) // The cumulative Estimated cost (Forecast). // ESTIMATED COST(Actual) up to the selected Cut-Off Period, followed by ESTIMATED COST(Forecast) figures beyond the selected Cut-Off Period. // Amount = Cumulative Estimated Cost, mix of ACTUAL and FORECAST, Accounting currency, General Ledger. |
| Estimated Income (Forecast) | Y | N | Cumulative Estimated Income, ACTUAL or FORECAST, Accounting currency, General Ledger. | SUM | N | [Estimated Revenue (Forecast)] - [Estimated Cost (Forecast)] |
| Estimated Margin (Forecast) | Y | N | Cumulative Estimated Margin, ACTUAL or FORECAST, Accounting currency, General Ledger. | SUM | N | DIVIDE([Estimated Income (Forecast)], [Estimated Revenue (Forecast)]) // Cumulative Estimated Margin, ACTUAL or FORECAST, Accounting currency, General Ledger. // Estimated Margin(%) calculated as Estimated Income (Forecast) / Estimated Revenue (Forecast). |
| Estimated Cost (Forecast) X-Rate | Y | N | Cumulative Estimated Cost, ACTUAL or FORECAST, X-rate currency, General Ledger. | SUM | N | VAR ActualAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Estimated Cost (Actual)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR ForecastAmount = ADDCOLUMNS( SUMMARIZE('FACT FORECAST AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Estimated Cost (Forecast)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR ResultActual = SUMX(ActualAmount, [@GLAmount] * [@XRates]) VAR ResultForecast = SUMX(ForecastAmount, [@GLAmount] * [@XRates]) RETURN IF( SELECTEDVALUE('REPORTING PERIOD'[Reporting Year Period]) <= [SelectedCutOffPeriod], ResultActual, ResultForecast) // Amount = Cumulative Estimated Cost, ACTUAL and FORECAST, X-rate currency, General Ledger. ) |
| Estimated Revenue (Forecast) X-Rate | Y | N | Cumulative Estimated Revenue, ACTUAL or FORECAST, X-rate currency, General Ledger. | SUM | N | VAR ActualAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Estimated Revenue (Actual)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR ForecastAmount = ADDCOLUMNS( SUMMARIZE('FACT FORECAST AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Estimated Revenue (Forecast)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR ResultActual = SUMX(ActualAmount, [@GLAmount] * [@XRates]) VAR ResultForecast = SUMX(ForecastAmount, [@GLAmount] * [@XRates]) RETURN IF( SELECTEDVALUE('REPORTING PERIOD'[Reporting Year Period]) <= [SelectedCutOffPeriod], ResultActual, ResultForecast) // Amount = Cumulative Estimated Revenue, ACTUAL and FORECAST, X-rate currency, General Ledger. |
| Estimated Income (Forecast) X-Rate | Y | N | Cumulative Estimated Income, ACTUAL or FORECAST, X-rate currency, General Ledger. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Estimated Income (Forecast)]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // Amount = Cumulative Estimated Income, ACTUAL and FORECAST, X-rate currency, General Ledger. |
| Estimated Margin (Forecast) X-Rate | Y | N | Cumulative Estimated Margin, ACTUAL or FORECAST, X-rate currency, General Ledger. | SUM | N | DIVIDE([Estimated Income (Forecast) X-Rate], [Estimated Revenue (Forecast) X-Rate]) // Cumulative Estimated Margin, ACTUAL and FORECAST, X-rate currency, General Ledger. // Estimated Margin(%) calculated as Estimated Income / Estimated Revenue. |
| Estimated Cost (Forecast) | Y | N | Cumulative Estimated Cost, ACTUAL or FORECAST, Accounting currency, General Ledger. | SUM | N | IF( SELECTEDVALUE('REPORTING PERIOD'[Reporting Year Period]) <= [SelectedCutOffPeriod], [Estimated Cost (Actual)], CALCULATE( SUM('FACT FORECAST AMOUNTS'[ESTIMATED_COST]), FILTER( 'FORECAST VERSION', 'FORECAST VERSION'[Ledger ID] = "00" || 'FORECAST VERSION'[Ledger ID] = "*" ) ) ) // The cumulative Estimated cost (Forecast). // ESTIMATED COST(Actual) up to the selected Cut-Off Period, followed by ESTIMATED COST(Forecast) figures beyond the selected Cut-Off Period. // Amount = Cumulative Estimated Cost, mix of ACTUAL and FORECAST, Accounting currency, General Ledger. |
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 |
| Model Name |
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 |
| GENERAL LEDGER MEASURES | N/A | N/A | N/A |