Why don’t we rename new calculated line to help you EditionID. You might rename one line by the double-clicking they, or because of the right-pressing this new column and you will choosing Rename Line. Whenever accomplished, the brand new Servers desk when you look at the Fuel Rotate ends up the second monitor.
The newest Servers desk is prepared. Next let’s perform a calculated line for the Medals that matches the new style of one’s EditionID line i established in Servers, so we can cause a relationship among them.
Start by doing another line about Medals table, eg i performed to possess Computers. For the Stamina Pivot discover the Medals desk, and click Design > Columns > Create. Observe that Create Column is chosen. It’s got a comparable impact given that merely interested in Include Column.
I developed the EditionID line to do something since the Hosts table first key (novel, non-repeated occupation), and you will created an enthusiastic EditionID column regarding Medals dining table to enable business regarding a love between them
The new Edition line in Medals has an alternative format as compared to Version line in Computers. In advance of we merge, or concatenate, the fresh Release line to the Year line which will make the newest EditionID line, we need to manage an intermediary industry one to will get Version into the just the right structure. Regarding the formula bar over the dining table, kind of another DAX algorithm.
When you find yourself strengthening this new algorithm, force Enter into. Opinions is inhabited for all the rows about determined column, in line with the formula your registered. For those who compare which line to your Edition column within the Hosts, you will observe that these articles have the same format.
Once you written another type of line, Fuel Rotate added various other placeholder column named Put Column. Next we need to create the EditionID calculated column, so find Add Line. From the formula club, type next DAX algorithm and you will press Go into.
See of a lot viewpoints try frequent from the Medals dining table EditionID job. Which is ok and you may questioned, because the during for each model of one’s Olympics (today illustrated from the EditionID value) many medals was granted. What’s book from the Medals dining table is actually for each given medal. Exclusive identifier for each list from the Medals table, and its appointed primary trick, ‘s the MedalKey occupation.
From the Stamina Pivot windows, discover Domestic > Take a look at > Drawing See throughout the bend. You may also option between Grid view and Drawing evaluate using brand new keys towards the bottom of your PowerView windows, since the found regarding adopting the screen.
Grow Servers so you can consider each of the areas. Stamina Pivot will bring an observe function into bend, to help you lookup important computer data Model getting corresponding industries. Next display reveals the fresh Look for Metadata screen, having EditionID joined from the Discover What career.
Drag the fresh new EditionID line inside Medals towards the EditionID line into the Computers. Energy Pivot produces a love involving the dining tables based on the EditionID line, and you may draws a line among them articles, showing the relationship.
Within https://datingranking.net/escort-directory/high-point/ this section, your learned an alternative way of including brand new columns, written a computed column playing with DAX, and you may put that line to establish an alternative relationships between tables. The latest Hosts dining table is incorporated into the details Design, and its data is offered to the PivotTable inside the Sheet1. It is possible to use the related analysis to help make even more PivotTables, PivotCharts, Strength View reports, and much more.
Manage a steps
Very Data Habits is studies that is naturally hierarchicalmon for example diary investigation, geographical data, and you will device classes. Starting hierarchies in this Electricity Rotate is useful since you may pull you to definitely goods in order to a study – this new steps – as opposed to needing to collect and you will acquisition an identical fields over as well as over.
Нет Ответов