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.

FY24CompletedEBCBySpeaker

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

EVALUATE
SUMMARIZECOLUMNS
(
'Architect_MTC'[ContactID],
'FactEngagement_MTC'[EngagementID],
'Architect_MTC'[EMailAddress1],
'FactEngagement_MTC'[StartDateID],
'FactEngagement_MTC'[EngagementStatus_New],
'FactEngagement_MTC'[EngagementTitle],
'mtc_MTC'[MTCLocation],
FILTER('FactEngagement_MTC', 'FactEngagement_MTC'[StartDateID] >= 20230701 && 'FactEngagement_MTC'[EngagementStatus_New] = "Complete"),
FILTER('EngagementType_MTC', 'EngagementType_MTC'[IsCore] = "Core"),
"EngagementCount", [EngagementCount]
)