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.

EngagementMilestone

Data source: KPILakeAS

EVALUATE
SUMMARIZECOLUMNS
(
'Engagement'[Engagement CRM-ID],
'Engagement Milestone Usage'[Milestone CRM-ID],
'Engagement Milestone Usage'[Engagement Milestone Name],
'Engagement Milestone Usage'[Milestone Owner],
'Engagement Milestone Usage'[Milestone Owner Standard Title],
'Engagement Milestone Usage'[Milestone Category],
'Engagement Milestone Usage'[Milestone Workload],
'Engagement Milestone Usage'[Workload Type],
'Engagement Milestone Usage'[Estimated Date],
'Engagement Milestone Usage'[Milestone Status],
'Engagement Milestone Usage'[Milestone Status Reason field],
'Engagement Milestone Usage'[Non Recurring],
'Engagement Milestone Usage'[Help Needed],
'Engagement Milestone Usage'[Created By],
'Engagement Milestone Usage'[Create Date],
'Engagement Milestone Usage'[Milestone Ownership Group],
FILTER('Engagement Milestone Usage', OR (Left('Engagement Milestone Usage'[Milestone Workload],17) in { "Infra: Azure Sec ","Infra: Monitoring"},'Engagement Milestone Usage'[Milestone Workload] in {"Infra: Native Azure Virtual Desktop","Infra: Citrix + Azure Virtual Desktop","Infra: Horizon + Azure Virtual Desktop (VMware)","MW: Teams Phone"}))
)