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.

BilledRevenuePartner2

Data source: KPILakeAS

EVALUATE
SUMMARIZECOLUMNS
(
'Solution Area'[Commercial Workload],
'Partner'[Partner ID],
'Partner'[Partner Name],
'MAL'[TPID],
'MAL'[Top Parent],
'Geography'[Area],
'Geography'[Subsidiary],
'Transaction Type'[Transaction Type],
'Product'[Super Rev Sum Division],
'Product'[Rev Sum Division],
'Product'[Rev Sum Category],
'Product'[Product Family],
'Product'[Dynamics Workload],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'Pricing Level'[Reporting Summary Pricing Level],
'Pricing Level'[Business Type],
'Segment'[Field Segment],
'Solution Area'[MW Cloud Proxy Flag],
'Sales Group'[Sales Unit],
'Segment'[SubSegment],
'Account Information'[Industry],
'Account Information'[Vertical],
FILTER('Product', 'Product'[Super Rev Sum Division] in {"Power BI - M365","Power BI - Non M365"}  ),
FILTER('Calendar', 'Calendar'[Fiscal Year] >= "FY21"),
"Initiated Units",Blank(),
"Billed Revenue",[Billed Revenue],
"Actual Licenses",Blank()
)