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.

SupportNetNewCustomersSBR

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

EVALUATE
SUMMARIZECOLUMNS (
'Date'[MS Fiscal Month Name],
'Date'[Is Current MS Fiscal Month],
'Date'[Active Till Currrent Month],
'Net New Customers'[MS Sales Top Parent ID],
FILTER (
'Date',
OR (
'Date'[Is Current MS Fiscal Year] == "Y",
'Date'[Is Prior MS Fiscal Year] == "Y"
)
),
"Net New Customers YTD", [NetNew Customers YTD],
"Net New Customers YTD PY]", [NetNew Customers YTD PY],
"Net New Customers SBR YTD", [NetNew Customers SBR YTD],
"Net New Customers SBR YTD PY", [NetNew Customers SBR YTD PY]
)