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.

ACR

Data source: AzureDashboardAS

EVALUATE
SUMMARIZECOLUMNS
(
'Account Information'[TPID],
'Geography'[Area],
'Geography'[Subsidiary],
'Azure Subscription'[Subscription GUID],
'Azure FRA Group'[Strategic Pillar],
'Service Comp Grouping'[Service Comp Grouping],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'Azure Service'[Service Level 1],
'Azure Service'[Service Level 2],
'Azure Service'[Service Level 3],
'Azure Service'[Service Level 4],
'Azure Service'[Service Level 5],
'Pricing Level'[AZ Pricing Level],
'Pricing Level'[AZ Pricing Level 2],
FILTER('ACR Adjustment Type','ACR Adjustment Type'[ACR Adjustment Type]=="N/A"),
FILTER('Solution Area','Solution Area'[Solution Area]=="Data & AI"),
"Azure Consumed Revenue",[Azure Consumed Revenue],
"Azure Consumed Revenue Paid Units",[Azure Consumed Revenue Paid Units]
)