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.

SupportOpportunityDealContract

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

evaluate
summarizecolumns
(
'Top Parent Account'[MS Sales Top Parent ID],
'Opportunity'[Opportunity ID],
'Opportunity'[Licensing Program Name],
'Date'[MS Fiscal Year Name],
'Deal'[Deal ID],
'Deal'[Deal Hyperlink],
'Deal'[RelatedDealId],
'Deal Contract'[Deal Contract ID],
'Deal Contract'[Deal Contract Hyperlink],
'Deal Contract'[Deal Contract Start Fiscal Year],
'Deal Contract'[Deal Contract Start Fiscal Quater],
'Deal Contract'[Deal Contract Start Fiscal Month],
'Deal Contract'[Deal Contract Start Date],
'Deal Contract'[Deal Contract End Date],
'Deal Contract'[Deal Contract Created Date],
'Deal Contract'[Deal Contract Approval Complete Date],
'Deal Contract'[Deal Contract Complete Date],
'Deal Contract'[Deal Contract Status Group],
'Deal Contract'[Deal Contract Status],
'Deal Contract'[Is Current],
'Deal Contract'[Valid],
'Deal Contract'[Is Multi-Year Deal],
'Delivery Contract'[Delivery Contract Number],
'Delivery Contract'[Delivery Contract Start date],
'Delivery Contract'[Delivery Contract End date],
'Delivery Contract'[Delivery Contract Status],
'Offering Level'[Unified Offering Level],
'Premier Support Model'[Premier Support Model],
'Service Line Offering'[PPG Category],
'Service Line Offering'[PPG],
'Top Parent Account'[CSAM Alias],
'Delivery Contract'[Delivery Contract Title],
'Delivery Contract'[SoldToMSSalesTPID],
'Service Line Offering'[Business Scenario],
'Service Line Offering'[OfferingGroup],
'Service Line Offering'[OfferingType],
filter('Date','Date'[MS Fiscal Year Name]>="FY2022"),
"Deal Contract Count",[Deal Contract Count],
"Deal Count",[Deal Count],
"Planned Package Gross RevenueUSD",[Planned Package Gross RevenueUSD],
"Planned Price To Clustomer USD",[Planned Price To Customer USD],
"Sold Margin USD",[Sold Margin USD]
)