mechanix 85, чудесный рост N07B - ANTISMOKING PRODUCTS в Армении
Что-то совсем "ленивый" пример Вы составили
Данные не плоские, модели нет...
Код |
---|
Sales Amount With Forecast:=
SUMX (
CROSSJOIN (
VALUES ( 'dim_countries'[COUNTRY] );
VALUES ( 'dim_pruducts'[EPHMRA-3] );
SELECTCOLUMNS (
'dim_years';
"year"; 'dim_years'[YEAR];
"indicator"; 'dim_years'[INDICATOR]
)
);
VAR forecastY =
CALCULATE (
MAX ( 'dim_years'[YEAR] );
ALL ( 'dim_years' );
'dim_years'[indicator] = "factForForecast"
)
VAR salesForecastY =
CALCULATE (
SUM ( 'sales'[SALES] );
ALL ( 'dim_years' );
'dim_years'[YEAR] = forecastY
)
VAR salesPreForecastYear =
CALCULATE (
SUM ( 'sales'[SALES] );
ALL ( 'dim_years' );
'dim_years'[YEAR] = forecastY - 1
)
VAR countYears = [year] - forecastY
VAR coeff =
POWER ( DIVIDE ( salesForecastY; salesPreForecastYear ); countYears )
VAR result =
IF (
[indicator] = "forecast";
coeff * salesForecastY;
CALCULATE ( SUM ( 'sales'[SALES] ) )
)
RETURN
result
) |