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.

SupportActiveContract

Data source: powerbi://api.powerbi.com/v1.0/myorg/ESA_CES_Prod

EVALUATE
SUMMARIZECOLUMNS(
'Top Parent Account'[MS Sales Top Parent ID],
'Top Parent Account'[MS Sales Top Parent Name],
'Delivery Contract'[Delivery Contract Number],
'Delivery Geography'[Area Name],
'Delivery Geography'[Subsidiary  Name],
'Delivery Geography'[Sales District Name],
'Delivery Geography'[Sales Sub District Name],
'Segment'[Custom Segment],
'Delivery Contract'[Delivery Contract Hyperlink],
'Delivery Contract'[Delivery Contract Title],
'Delivery Contract'[Delivery Contract Status],
'Delivery Contract'[Contract Status],
'Delivery Contract'[Contract Duration],
'Service Offering'[ServiceName],
'Component'[Component Name],
'Delivery Contract'[Delivery Contract Start date],
'Delivery Contract'[Delivery Contract End date],
'Service Line Offering'[Business Scenario],
'Service Line Offering'[PPG],
'Service Line Offering'[PPG Category],
'Delivery Contract'[Is Extension Active],
'Delivery Contract'[Is Valid],
filter('Delivery Contract','Delivery Contract'[Contract Status]="Active"),
"Schedule Used Hours",[Schedule Used Hours],
"Prorated Sold Hours",[Prorated Sold Hours],
"Prorated Burn Rate %",[Prorated Burn Rate %]
)