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.

EAExpirationRenewal

Data source: kpilakeas

EVALUATE
SUMMARIZECOLUMNS(
'MAL'[TPID],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'EA Expirations and Renewals'[Enrollment Number],
'EA Expirations and Renewals'[Expirations Renewals Flag],
'EA Expirations and Renewals'[Renewals for IQRR],
'EA Expirations and Renewals'[FirstBilledExpirationQuarterOffset],
'EA Expirations and Renewals'[ExpirationRenewalQuarterOffset],
'EA Expirations and Renewals'[Was Renewed],
'Solution Area'[Commercial Workload],
'Product'[Super Rev Sum Division],
'Product'[Rev Sum Division],
'Product'[Rev Sum Category],
'Product'[Product Family],
'EA Expirations and Renewals'[Expirations for IQRR],
filter('Calendar','Calendar'[Fiscal Year]>="FY22"),
filter('Solution Area','Solution Area'[Solution Area]="Business Applications"),
"Annualized C Without L",[Annualized C Without L]
)