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.

ACRwithSAPRISEAdjustment

Data source: AzureDashboardAs

EVALUATE
SUMMARIZECOLUMNS
(
'Account Information'[TPID],
'Geography'[Area],
'Geography'[Subsidiary],
'Account Information'[Sales Unit],
'Account Information'[SubSegment],
'Field Accountability Unit'[Field Area],
'Field Accountability Unit'[Field Accountability Unit],
'Field Accountability Unit'[Field Subsidiary],
'Azure FRA Group'[Strategic Pillar],
'Azure FRA Group'[Azure FRA Group 1],
'Azure FRA Group'[Azure FRA Group 2],
'Azure FRA Group'[Azure FRA Group 3],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'Pricing Level'[AZ Pricing Level],
'Pricing Level'[AZ Pricing Level 2],
'IsSAPSubscription Flag'[SAP Subscription Flag],
FILTER('ACR Adjustment Type','ACR Adjustment Type'[ACR Adjustment Type]=="N/A"),
"Azure Consumed Revenue",[Azure Consumed Revenue],
"SAP RISE ACR",[SAP RISE ACR],
"ACR with SAP RISE Adjustment",[ACR with SAP RISE Adjustment]
)