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.

TPExpirationFilter

Data source: WCSAS

EVALUATE
SUMMARIZECOLUMNS
(
'Calendar Expiration'[Expiration Year],
FILTER('Calendar Expiration', 'Calendar Expiration'[Expiration Year] >= "FY22"),
FILTER('Product','Product'[Solution Area] in {"Modern Work","Security","Modern Work & Security"}),
"SA Expiration $",[SA Expiration $],
"Expiration Total $",blank(),
"MS Sales Amount C without L",[MS Sales Amount C without L],
"MS Sales Licenses",[MS Sales Licenses],
"In Quarter Renewal $",[In Quarter Renewal $]
)