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.

RiseWinsIPCS

Data source: GPSInsightsASCRM

EVALUATE
SUMMARIZECOLUMNS
(
'Customer Segment'[Segment],
'Customer'[TP Account],
'Customer'[TP Account ID],
'Partner Deal'[Partner Deal Registration Date],
'Partner Deal'[Partner Deal Approval Date],
'Partner Deal'[Referral Sub Type],
'Partner Deal'[Partner Deal Direction],
'Partner Deal'[MSFTReferralID],
'Partner Deal Team'[ReferralID],
'Opportunity'[Opportunity Number],
'Opportunity'[Opportunity Name],
'Opportunity'[Opportunity Owner],
'Solution'[Solution Name],
'Reporting Geography'[Subsidiary],
filter('Account','Account'[Partner Sub Segment]="GISV"),
filter('Partner Deal','Partner Deal'[PartnerOne Name]="SAP"),
"Approved ACV",[Approved ACV (Azure)]
)