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.

SurfaceM365Fact

Data source: KPILakeMWAS

EVALUATE
SUMMARIZECOLUMNS (
'Credited Partner'[Partner One ID],
'Credited Partner'[Partner One Name],
'Credited Partner'[ResellerTPAccountId],
'Geography'[Area],
'Geography'[Subsidiary],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'Product'[Super Rev Sum Division],
'Product'[Rev Sum Division],
'Product'[Rev Sum Category],
'Product'[Product Family],
FILTER('Product', 'Product'[Super Rev Sum Division] IN { "O365 - M365 Suites Core", "O365 - M365 Suites E5" }),
FILTER('Calendar', 'Calendar'[Fiscal Year] >= "FY20"),
"Paid_Initiated_Units", 'Reporting Measures'[Paid Initiated Units]
)