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.

MarketplaceOfferBilledSales

Data source: MarketplaceDashboardAS

evaluate
summarizecolumns
(
'Invoice'[Enrollment Number],
'Invoice'[Billing Period Start Date],
'Invoice'[Billing Period End Date],
'Marketplace Offer'[Offer Display Name],
'Marketplace Offer'[First Live Publish Date],
'Marketplace Offer'[GTM Type],
'Marketplace Offer'[Offer Status],
'Marketplace Offer'[Offer Type],
'Marketplace Offer'[Offer ID],
'Account Information'[TPID],
'Account Information'[Top Parent],
'Geography'[Area],
'Geography'[Subsidiary],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'Marketplace Offer'[Transactable Offer Excluding Private Flag],
'Marketplace Offer'[Transactable Offer Inclusive Private Flag],
filter('Marketplace Offer','Marketplace Offer'[Offer Display Name] IN {"Room Connector for Microsoft Teams","Microsoft Enterprise Teams Connector by Pexip","Pexip Cloud Video Interop for Microsoft Teams","Pexip CVI for Microsoft Teams - as a Service","CentOS 7.6"}),
"Billed Sales - Invoice",[Billed Sales - Invoice],
"Customer Count - Invoice",[Customer Count - Invoice],
"Product Count Sold - Invoice",[Product Count Sold - Invoice]
)