Let’s rename the calculated line so you can EditionID. You could potentially rename one line because of the twice-pressing they, otherwise because of the best-clicking the line and you may choosing Rename Line. Whenever complete, new Machines table inside the Stamina Pivot looks like the next display.

The fresh new Hosts table is ready. Second why don’t we do a determined line from inside the Medals which fits the latest style of your own EditionID column we established in Computers, so we can produce a love between them.

Begin by carrying out an alternate line regarding the Medals dining table, including i did to own Machines. Within the Energy Rotate get the Medals desk, and then click Build > Articles > Create. See that Put Column is selected. This has a comparable perception due to the fact simply interested in Put Column.

I created the EditionID line to behave because Hosts desk number one key (book, non-constant community), and you will authored an enthusiastic EditionID column regarding the Medals desk to enable institution from a romance between them

The latest Version column into the Medals possess a different style versus Release line in the Servers. In advance of i combine, or concatenate, brand new Release line on the Season column which will make the brand new EditionID line, we need to create an intermediary occupation one to becomes Edition into the right format. Regarding the formula bar over the table, form of next DAX formula.

When you wind up strengthening the algorithm, drive Get into. Beliefs are populated for the rows regarding determined column, based on the formula your inserted. For many who evaluate that it column towards the Version line in the Servers, you will notice these particular articles have a similar style.

Once you written another type of line, Power Pivot added another placeholder column called Put Line. 2nd we would like to produce the EditionID computed line, so find Include Line. Regarding the formula pub, type the following DAX algorithm and you can press Go into.

Notice many opinions is constant in the Medals table EditionID occupation. That is ok and you will questioned, as the throughout for every single version of your own Olympics (now portrayed because of the EditionID really worth) of a lot medals was basically given. What is book regarding the Medals desk are each given medal. The unique identifier for every single number from the Medals dining table, and its appointed no. 1 secret, is the MedalKey occupation.

Regarding Stamina Pivot window, come across Household > Take a look at > Drawing See about ribbon. You could button between Grid consider and you may Drawing consider using this new keys in the bottom of one’s PowerView window, since revealed regarding the pursuing the display.

Develop Servers in order to take a look at all of its fields. Energy Pivot will bring a see feature toward bend, to lookup your computer data Model getting relevant fields. Next display reveals the brand new Pick Metadata windows, which have EditionID registered throughout the Get a hold of Exactly what career.

Drag the newest EditionID line within the Medals towards the EditionID line inside the Servers. Electricity Rotate creates a romance involving the tables based on the EditionID line, and you can pulls a column among them columns, showing the connection.

Within point, you read another type of way of adding the fresh columns, authored a determined line playing with DAX, and you may used one to column to ascertain a different sort of matchmaking anywhere between dining tables. New Computers desk has grown to become utilized in the information and knowledge Design, and its particular information is open to this new PivotTable into the Sheet1. You may also make use of the relevant investigation which will make extra PivotTables, PivotCharts, Power Consider reports, and much more.

Would a steps

Really Study Activities is investigation which is naturally hierarchicalmon for example calendar studies, geographic analysis, and you will product kinds. Performing hierarchies inside Power Rotate is good because you can drag you to definitely goods in order to a study – the hierarchy – in place of having https://datingranking.net/tr/firstmet-inceleme/ to gather and you will buy a similar fields over as well as over.