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.

ECIFMeasure

Data source: ECIFAS

EVALUATE
SUMMARIZECOLUMNS
(
'ECIF Case'[Case Id],
'ECIF Program'[Program Year],
'ECIF Case'[Engagement Id],
'Opportunity'[Opportunity CRM Id],
'ECIF Case'[Engagement Name],
'Opportunity'[Opportunity Name],
FILTER('ECIF Program', 'ECIF Program'[Program Year] >= "FY20"),
"ECIF Case Count",[ECIF Case Count],
"ECIF Committed", [ECIF Committed],
"ECIF Actual",[ECIF Actual],
"ECIF Committed CY",[ECIF Committed CY],
"ECIF Spend Plan Forecast",[ECIF Spend Plan Forecast]
)