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.

TPUsageKPILakeTarget

Data source: KPILakeAS

EVALUATE
SUMMARIZECOLUMNS
(
'Geography'[Area],
'Geography'[SubRegion],
'Segment'[Field Segment],
'Segment'[SubSegment],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'Managed Measure'[Measure],
'Sales Group'[Sales Unit],
filter('Managed Measure','Managed Measure'[Measure] in {
"Teams Platform MAU",
"Teams Phone",
"Teams PAU",
"Teams Meetings MAU",
"Teams MAU EDU",
"Teams MAU",
"Phone system standalone Subscribers",
"Phone System PAU","FLW PAU",
"FLW MAU",
"E5 Subscribers",
"Teams Phone Enabled Users",
"Phone PAU",
"Teams Rooms MAD",
"Teams Rooms",
"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"),
"Target",[Target]
)