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.

TPUsageKPILake3

Data source: KPILakeAS

EVALUATE
SUMMARIZECOLUMNS
(
'MAL'[TPID],
'MAL'[Top Parent],
'Geography'[Area],
'Geography'[Subsidiary],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'Managed Measure'[Measure],
filter('Managed Measure','Managed Measure'[Measure] in {
"Rooms PAU",
"Teams Device Activations",
"Windows 11 MAD",
"AADP P2 MPU",
"AADP P1 PaidAvailableUnits",
"AADP P2 PAU",
"E5 Security Usage",
"E5 Compliance Usage"
}),
filter('Calendar','Calendar'[Fiscal Year]>="FY21"),
"Value",[Numerator]
)