Note:
This content is automatically generated by the ETL tool.
Last build time is2024-03-19 13:44:37
. Please contact MWS Insights Data Infrastructure for the query.
DimCustomerSurfaceMSXI
Data source: powerbi://api.powerbi.com/v1.0/myorg/%2AMSXI%20Surface
evaluate
summarizecolumns
(
'DimCustomer'[3rdResellerName],
'DimCustomer'[3rdResellerUnits],
'DimCustomer'[Account Name],
'DimCustomer'[AccountManager],
'DimCustomer'[AccountStatus],
'DimCustomer'[AccountType],
'DimCustomer'[Accts Hub > 0 # of Devices],
'DimCustomer'[Accts Hub > 1 # of Devices],
'DimCustomer'[ATUGROUP],
'DimCustomer'[ATUGroupManager],
'DimCustomer'[ATUManager],
'DimCustomer'[ATUName],
'DimCustomer'[ATUSalesTerritory],
'DimCustomer'[Child Account Lookup View Link],
'DimCustomer'[CountryUS/OU],
'DimCustomer'[CRMAccountID],
'DimCustomer'[Customer],
'DimCustomer'[Customer Profile View Link],
'DimCustomer'[Customer_Search],
'DimCustomer'[CY_surfaceGrossCustomerAdd],
'DimCustomer'[D365 >50 Pipeline],
'DimCustomer'[D365 C+CAR Pipeline],
'DimCustomer'[D365 Seats],
'DimCustomer'[D365 Sold Seats],
'DimCustomer'[D365 Sold Seats > 50],
'DimCustomer'[DunsNumber],
'DimCustomer'[E300Vertical],
'DimCustomer'[EligibleGrossCustomerAdds],
'DimCustomer'[GPName],
'DimCustomer'[HQ_DS],
'DimCustomer'[Industry],
'DimCustomer'[IS_SMBUU],
'DimCustomer'[IsCMODS],
'DimCustomer'[IsDim_customer],
'DimCustomer'[IsNRO],
'DimCustomer'[IsWWMAL],
'DimCustomer'[M365 > 250 Pipeline Seats],
'DimCustomer'[M365 Eligible],
'DimCustomer'[M365 FirstLine Pipeline Units],
'DimCustomer'[M365 Frontline C+CAR Pipeline Units YTD],
'DimCustomer'[M365 Frontline EOP Seats],
'DimCustomer'[M365 Offer Flag],
'DimCustomer'[M365 Pipeline Units],
'DimCustomer'[M365 Seats],
'DimCustomer'[M365 Sold Seats],
'DimCustomer'[M365 Sold Seats > 250],
'DimCustomer'[M365 without Surface Attached (Units needed)],
'DimCustomer'[M365CommercialSubscriptionEndDate],
'DimCustomer'[M365Reseller],
'DimCustomer'[M365withSurfaceAttachedFlag],
'DimCustomer'[MALCompanyName],
'DimCustomer'[MSTeamsUsage],
'DimCustomer'[O365CommercialSubscriptionEndDate],
'DimCustomer'[PCIB FY20],
'DimCustomer'[PDM],
'DimCustomer'[Portfolio Maturity Index T52],
'DimCustomer'[Portfolio Maturity Index_T52],
'DimCustomer'[PostalCode],
'DimCustomer'[PrimaryResellerName],
'DimCustomer'[PrimaryReSellerType],
'DimCustomer'[PrimaryResellerUnits],
'DimCustomer'[SalesLocationID],
'DimCustomer'[SalesProgram1],
'DimCustomer'[SalesProgram2],
'DimCustomer'[salesterritoryid],
'DimCustomer'[SecondaryOrgGlobalParent],
'DimCustomer'[SecondaryOrgTopParent],
'DimCustomer'[SecondaryResellerName],
'DimCustomer'[SecondaryResellerUnits],
'DimCustomer'[SecondaryTPID],
'DimCustomer'[SSMModernWorkplace],
'DimCustomer'[SSPManagerModernWorkplace],
'DimCustomer'[SSPManagerSurface],
'DimCustomer'[SSPModernWorkplace],
'DimCustomer'[SSPSurface],
'DimCustomer'[StrategicAcct],
'DimCustomer'[SubSegment],
'DimCustomer'[Surface Hub Pipeline],
'DimCustomer'[Surface Hub Pipeline C+CAR],
'DimCustomer'[Surface PC Pipeline C+CAR],
'DimCustomer'[Surface Pipeline Units MSX],
'DimCustomer'[Surface_SSP],
'DimCustomer'[Surface_TSP],
'DimCustomer'[Surface+ Offer Eligible],
'DimCustomer'[Surface2],
'DimCustomer'[SurfacePipelineUnits],
'DimCustomer'[Tier PC Baseline FY21],
'DimCustomer'[Tier PC Baseline FY22],
'DimCustomer'[Vertical],
'DimCustomer'[VerticalCategory],
'DimCustomer'[VirtuousUpsell],
'DimCustomer'[WindowsCommercialSubscriptionEndDate],
'dimsaleslocation'[SalesLocation],
)