Note: This content is automatically generated by the ETL tool. Last build time is 2024-03-19 13:44:37. Please contact MWS Insights Data Infrastructure for the query.

ACRForecast

Data source: KPILakeSummaryAS

evaluate
selectcolumns(
summarizecolumns
(
Geography[Area Short Name],
'Field Geography'[Field Custom Area],
'Field Geography'[Field Subsidiary],
Segment[Field Segment],
Segment[SubSegment],
Calendar[Fiscal Year],
Calendar[Fiscal Quarter],
Calendar[Fiscal Month],
'Pricing Level'[AZ Pricing Level],
'Solution Area'[Solution Area],
'Azure FRA Group'[Strategic Pillar],
'US Commercial OU'[US High Segment],
'US Commercial OU'[US Commercial OU],
'US Commercial OU'[Is Federal],
'Field Accountability Unit'[Field Area],
'Field Accountability Unit'[Field Accountability Unit],
'Field Accountability Unit'[Field Subsidiary],
FILTER('ACR Adjustment Type','ACR Adjustment Type'[ACR Adjustment Type]="N/A"),
FILTER(Calendar,Calendar[Fiscal Year]>="FY23"),
"ACR Forecast",VAR acrfor=[Azure Consumed Revenue Forecast] RETURN IF(acrfor=0,BLANK(),acrfor)
),
"Area",Geography[Area Short Name],
"FieldCustomArea",'Field Geography'[Field Custom Area],
"FieldSubsidiary",'Field Geography'[Field Subsidiary],
"FieldSegment",Segment[Field Segment],
"SubSegment",Segment[SubSegment],
"FiscalYear",Calendar[Fiscal Year],
"FiscalQuarter",Calendar[Fiscal Quarter],
"FiscalMonth",Calendar[Fiscal Month],
"AZPricingLevel",'Pricing Level'[AZ Pricing Level],
"SolutionArea",'Solution Area'[Solution Area],
"StrategicPillar",'Azure FRA Group'[Strategic Pillar],
"USHighSegment",'US Commercial OU'[US High Segment],
"USCommercialOU",'US Commercial OU'[US Commercial OU],
"IsFederal",'US Commercial OU'[Is Federal],
"ACR Forecast",[ACR Forecast],
"FieldArea",'Field Accountability Unit'[Field Area],
"FieldAccountabilityUnit",'Field Accountability Unit'[Field Accountability Unit],
"FieldAccountabilitySubsidiary",'Field Accountability Unit'[Field Subsidiary],
"ForecastVersion",VAR defVersion = [defaultFcstVersion] RETURN CALCULATE(MAX('Forecast Version'[Forecast Version]),KEEPFILTERS('Forecast Version'[CurrentForecastVersionFlagId] = defVersion))
)