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.

AMMPPartnerLed

Data source: asazure://aspaaseastus2.asazure.windows.net/msbizopspartneraasprod

DEFINE
var e  = CALCULATETABLE(
Values ('Engagement Configuration'[Engagement Id]),
LEFT('Engagement Configuration'[Engagement Name], 3)  = "AMM"|| LEFT('Engagement Configuration'[Engagement Name], 14)  = "Azure Innovate"
)
EVALUATE
SUMMARIZECOLUMNS(
'Workshop Claims'[Workshop ClaimId],
'Workshop Claims'[PaymentDocumentNumber],
'Workshop Claims'[Customer Claimed Date],
'Workshop Claims'[Customer Consent Last Sent Date],
'Workshop Claims'[Customer Consent Response Date],
'Workshop Claims'[Claim Approved On],
'Workshop Claims'[Workshop Claim Status],
'Workshop Claims'[Customer Name],
'Workshop Claims'[CustomerId Value],
'Workshop Claims'[Workshop Earning Amount USD],
'Workshop Claims'[Workshop Payout Amount USD],
'Engagement Configuration'[Engagement Name],
Partner[Partner ID],
Partner[Partner Name],
Partner[PartnerOneID],
Partner[PartnerOne Name],
'Partner Geography'[Partner Area],
e,
"Count", [Claims Count]
)