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.

TPUsageByWin

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

EVALUATE
SUMMARIZECOLUMNS
(
'Accounts'[TP Account ID],
'Accounts'[TP Account Name],
'Accounts'[Area Name],
'Accounts'[Subsidiary Name],
'Accounts'[Strategic Accounts Flag],
'WorkloadType'[Workload Type],
'WorkloadType'[Reporting Workload],
'FiscalMonth'[Year],
'FiscalMonth'[Month],
filter('WorkloadType','WorkloadType'[IsModernWorkplace]=1),
filter('FiscalMonth','FiscalMonth'[Year]>="FY21"),
filter('WorkloadType','WorkloadType'[Reporting Workload] in {"Windows 10 MAD","New Win 10 EDU Activations","New Win 10 EDU Device Activations","New Win 10 Pro OEM Devices"}),
"Numerator",[Win Numerator],
"Denominator",[Win Denominator],
"MoM%",[Win MoM %],
"QoQ%",[Win QoQ %],
"YoY%",[Win YoY %]
)