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.

SupportRenewal

Data source: powerbi://api.powerbi.com/v1.0/myorg/ESA_CES_Prod

EVALUATE
SUMMARIZECOLUMNS(
'Date'[MS Fiscal Year Name],
'Date'[MS Fiscal Qtr Name],
'Date'[MS Fiscal Month Name],
'Delivery Geography'[Area Name],
'Delivery Geography'[Subsidiary  Name],
'Delivery Geography'[Sales District Name],
'Delivery Geography'[Sales Sub District Name],
'Top Parent Account'[MS Sales Top Parent ID],
'Top Parent Account'[MS Sales Top Parent Name],
'Delivery Contract'[Delivery Contract Number],
'Delivery Contract'[Renewed To],
'Delivery Contract'[Renewed To Category],
'Delivery Contract'[Exp Premier Support Model],
'Delivery Contract'[Renewal Category],
filter('Date','Date'[MS Fiscal Year Name]>="FY2021"),
"Expired Delivery Contract Count",[Expired Delivery Contract Count],
"Renewal Delivery Contract Count",[Renewal Delivery Contract Count],
"Current Delivery Contract Renewal Annualized Revenue",[Current Delivery Contract Renewal Annualized Revenue],
"Current Delivery Contract Renewal Revenue",[Current Delivery Contract Renewal Revenue],
"Prev Delivery Contract Renewal Annualized Revenue",[Prev Delivery Contract Renewal Annualized Revenue],
"Prev Delivery Contract Renewal Revenue",[Prev Delivery Contract Renewal Revenue]
)