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.

FY24CompletedMTCAndEBCByRequestor

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

EVALUATE
SUMMARIZECOLUMNS
(
'FactEngagement_MTC'[RequesterEmail],
'FactEngagement_MTC'[EngagementID],
'EngagementType_MTC'[Type],
'FactEngagement_MTC'[RequesterName],
'FactEngagement_MTC'[StartDateID],
'FactEngagement_MTC'[EngagementStatus_New],
'EngagementType_MTC'[IsCore],
'FactEngagement_MTC'[EngagementTitle],
'mtc_MTC'[MTCLocation],
FILTER('FactEngagement_MTC', 'FactEngagement_MTC'[RequesterEmail] <> ""),
FILTER('FactEngagement_MTC', 'FactEngagement_MTC'[StartDateID] >= 20230701),
"EngagementCount", [EngagementCount]
)