Note:
This content is automatically generated by the ETL tool.
Last build time is2024-03-19 13:44:37
. Please contact MWS Insights Data Infrastructure for the query.
SupportConversionRate
Data source: powerbi://api.powerbi.com/v1.0/myorg/ESA_CES_Prod
EVALUATE
SUMMARIZECOLUMNS (
'Date'[MS Fiscal Qtr Name],
'Date'[MS Fiscal Month Name],
'Delivery Geography'[Area Name],
'Delivery Geography'[Sub Region Name],
'Delivery Geography'[Subsidiary Name],
'Offering Level'[Unified Offering Level],
'Offering Level'[Unified Offering Level Category],
'Premier Support Model'[Premier Support Model],
'Sales Geography'[Sales District Name],
'Segment'[SegmentType],
'Service Line Offering'[PPG],
'Service Line Offering'[PPG Category],
'Top Parent Account'[Custom Segment],
'Top Parent Account'[MS Sales Top Parent ID],
'Top Parent Account'[MS Sales Top Parent Name],
'Top Parent Account'[TP Sub Segment Name],
FILTER('Date', 'Date'[Is Current MS Fiscal Year] = "Y" && 'Date'[Active Till Currrent Month] = 1),
"UnifiedTPIDCount", [Unified TPID Count],
"SupportTPIDCount", [Support TPID Count]
)