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.

TPMCSInvolvement

Data source: PBIX

EVALUATE(
CALCULATETABLE(
SUMMARIZECOLUMNS(
Account[MS Sales TP ID],
Service[Service],
"Planned Service Revenue (CCUS)", [Planned Service Revenue (CCUS)],
"Resouce Hrs", [Resource Hrs]
)
,KEEPFILTERS(Contract[Contract Created Date Fiscal Year] IN {"FY20", "FY21", "FY22", "FY23"})
,KEEPFILTERS(Contract[Contract Version] IN {"Amendment", "Base Contract"})
,KEEPFILTERS(Contract[Contract Business Type] IN {"Combined", "Consulting"})
,KEEPFILTERS(Contract[Contract Status Group] IN {"In Review", "In Approval", "In Contract Assembly", "Ready for Signature", "In Agreement Setup", "Completed"})
,KEEPFILTERS(Contract[Is Budgetary Estimate] = FALSE)
,KEEPFILTERS(Service[Service] IN {"Azure Sentinel Enablement", "Security: Azure Sentinel - Fundamentals"})
)
)