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.

EngagementTeam

Data source: KPILakeAS

EVALUATE
SUMMARIZECOLUMNS(
'Engagement'[Engagement CRM-ID],
'Engagement Team'[Email],
'Engagement Team'[Standard Title],
FILTER('Engagement Workload', OR (Left('Engagement Workload'[Engagement Workload],17) in { "Infra: Azure Sec ","Infra: Monitoring"},'Engagement Workload'[Engagement Workload] in {"Infra: Native Azure Virtual Desktop","Infra: Citrix + Azure Virtual Desktop","Infra: Horizon + Azure Virtual Desktop (VMware)","MW: Teams Phone"} )),
"Row Count", COUNTROWS('Engagement Milestone Usage')
)