Begivenhed
31. mar., 23 - 2. apr., 23
Den største Fabric-, Power BI- og SQL-læringshændelse. 31. marts - 2. april. Brug koden FABINSIDER til at gemme $400.
Tilmeld dig i dagMDX Data Manipulation - Manipulating Data
Applies to: 
SQL Server Analysis Services 
Azure Analysis Services
Fabric/Power BI Premium
Multidimensional Expressions (MDX) can be used to manipulate the data in a variety of ways. The following topics cover some of the more advanced concepts of data manipulation in the MDX language
| Topic | Description |
|---|---|
| Using DRILLTHROUGH to Retrieve Source Data (MDX) | Discusses the use of the MDX DRILLTHROUGH statement to retrieve the rowsets of source data applicable to a cell in a multidimensional data source |
| Working with the RollupChildren Function (MDX) | Discusses the impact of the MDX RollupChildrenfunction on the analysis of multidimensional data. |
| Understanding Pass Order and Solve Order (MDX) | Details the concepts of solve order, and how this feature affects MDX expressions, statements, and scripts. |
Yderligere ressourcer
Træning
Modul
Transform data by implementing pivot, unpivot, rollup, and cube - Training
This content is a part of Transform data by implementing pivot, unpivot, rollup, and cube.
Certificering
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrer metoder og bedste fremgangsmåder, der er i overensstemmelse med forretningsmæssige og tekniske krav til modellering, visualisering og analyse af data med Microsoft Power BI.
Dokumentation
-
Learn how to use Multidimensional Expressions (MDX) to update or writeback dimension and cube data.
-
Working with the RollupChildren Function (MDX)
Learn how the Multidimensional Expressions (MDX) RollupChildren function rolls up the children of a member and applies a different unary operator to each child.
-
Building Subcubes in MDX (MDX)
In this article, learn how to use the CREATE SUBCUBE statement to define a subcube.