Let’s rename this new calculated line to help you EditionID. You might rename any line by double-clicking they, otherwise by proper-pressing the new line and you may choosing Rename Line. When completed, new Computers table within the Electricity Rotate works out another display screen.
New Hosts dining table is ready. Second let’s carry out a determined line within the Medals that matches the fresh new structure of EditionID line i established in Machines, so we can cause a love among them.
Start by starting an alternative column on the Medals table, instance we performed for Servers. Within the Energy Rotate select the Medals desk, and then click Structure > Articles > Add. Notice that Include Line is chosen. It’s got a comparable effect as merely selecting Add Line.
We created the EditionID line to behave once the Hosts dining table primary trick (novel, non-frequent occupation), and you will created an EditionID column regarding Medals dining table to allow institution regarding a love among them
Brand new Version column within the Medals enjoys a separate style compared to the Version column in the Machines. In advance of i mix, otherwise concatenate, the latest Edition column into the Seasons column to create the fresh EditionID line, we must create an intermediary industry that will get Edition into the just the right structure. Regarding algorithm pub above the dining table, particular another DAX formula.
After you become building the new formula, press Get into. Values is actually inhabited when it comes down to rows on computed column, according to the algorithm your joined. For people who examine so it line towards the Model column for the Machines, you will see these particular articles have the same structure.
When you created a different line, Fuel Rotate additional various other placeholder column entitled Include Column. 2nd we wish to produce the EditionID determined column, very get a hold of Include Column. Regarding the algorithm club, sort of the next DAX formula and you will push Get into.
See of several values try frequent regarding the Medals table EditionID profession. That’s ok and asked, due to the fact during for each release of the Olympics (now represented of the EditionID well worth) of many medals had been issued. What exactly is novel throughout the Medals desk try for every single issued medal. The unique identifier for each and every listing on the Medals dining table, and its particular appointed top secret, ‘s the MedalKey community.
From the Strength Rotate windows, select Home > See > Drawing Examine regarding the bend. You may also switch anywhere between Grid see and you will Drawing consider having fun with new keys at the end of your PowerView screen, as blk shown throughout the following the display screen.
Develop Machines so you can check each one of the sphere. Electricity Rotate will bring a see ability into bow, to help you research your computer data Design having involved industries. The next display reveals the latest Get a hold of Metadata windows, which have EditionID registered in the Pick Just what career.
Pull the brand new EditionID line inside Medals into the EditionID line for the Servers. Energy Pivot brings a love within dining tables based on the EditionID line, and draws a column between them articles, demonstrating the relationship.
Contained in this area, you read an alternate technique for including the fresh new articles, composed a determined column playing with DAX, and you may utilized that column to establish another type of matchmaking ranging from dining tables. The latest Computers dining table is starting to become included in the information and knowledge Design, as well as data is accessible to the new PivotTable when you look at the Sheet1. You may also use the related studies in order to make most PivotTables, PivotCharts, Strength Evaluate reports, plus.
Create a hierarchy
Very Research Habits were research which is inherently hierarchicalmon for example schedule research, geographical study, and you can device groups. Undertaking hierarchies within Power Rotate is useful as you may drag one to product in order to research – the latest steps – rather than having to gather and you may purchase a similar areas more and over.