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.

SupportActiveDealDiscount

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

EVALUATE
SUMMARIZECOLUMNS (
'Top Parent Account'[MS Sales Top Parent ID],
'Deal Contract'[Deal Contract End Fiscal Month],
'Service Line Offering'[PPG Category],
'Service Line Offering'[PPG],
'Deal Contract'[Deal Contract Status Group],
FILTER (
'Deal Contract',
'Deal Contract'[Deal Contract End Fiscal Year] >= "FY2024"
),
"Deal Discount Percentage Numerator",
SUM ( 'Current vs Previous Deal Package Fact'[Deal Discount Percentage Numerator] ),
"Planned Package SAB Revenue CCUS2",
SUM ( 'Current vs Previous Deal Package Fact'[Planned Package SAB Revenue CCUS2] ),
"Deal Discount Percentage Denomiator",
SUM ( 'Current vs Previous Deal Package Fact'[Deal Discount Percentage Denomiator] )
)