Zaznacz stronę

We need to find them one another, and construct a relationship

Let us rename the calculated column to help you EditionID. You might rename people line by twice-clicking they, otherwise because of the proper-clicking the newest column and you may opting for Rename Line. Whenever complete, this new Servers dining table in Energy Pivot works out the following display.

The newest Hosts table is prepared. Second let’s create a determined column inside Medals that matches brand new style of one’s EditionID column i established in Machines, therefore we can produce a relationship between the two.

Begin by creating yet another column in the Medals dining table, such we did to possess Servers. During the Stamina Rotate find the Medals dining table, and click Structure > Articles > Add. See that Include Line is chosen. It has got a comparable effect because simply wanting Include Column.

We created the EditionID line to do something as Hosts dining table top key (book, non-repeated job), and created an enthusiastic EditionID line on the Medals desk to enable place out of a relationship between the two

New Edition column for the Medals have an alternative style compared to Release line in Hosts. Before i mix, or concatenate, the fresh new Edition column toward Season line in order to make brand new EditionID line, we need to carry out an intermediary community one will get Version into suitable style. From the formula bar over the desk, style of the following DAX algorithm.

After you wind up building the fresh formula, force Get into. Opinions are inhabited for the rows in the calculated column, according to the algorithm you inserted. For many who compare this column to your Edition line in the Computers, you will observe that these articles have a similar format.

When you created a special line, Energy Rotate added some other placeholder column named Add Column. 2nd we should produce the EditionID computed line, so discover Incorporate Line. In the algorithm pub, method of the following DAX algorithm and you will drive Enter into.

Observe of many values was repeated about Medals dining table EditionID occupation. Which is ok and you will questioned, once the during the for each model of the Olympics (now portrayed from the EditionID worthy of) many medals was approved. What is novel about Medals dining table are for every single awarded medal. Exclusive identifier for every number from the Medals dining table, and its particular designated primary trick, 's the MedalKey community.

From the Stamina Rotate screen, come across Family > Evaluate > Drawing Examine on the bow. You may also option between Grid evaluate and you xpress-quizzen may Drawing see playing with brand new keys at the bottom of your PowerView screen, while the revealed on after the monitor.

Build Hosts to help you take a look at each one of the areas. Energy Rotate provides an observe ability on bow, to research your data Design having associated sphere. The following screen reveals the brand new Get a hold of Metadata window, with EditionID entered in the Look for Exactly what industry.

Drag brand new EditionID column in Medals toward EditionID line from inside the Machines. Strength Rotate produces a love between the dining tables according to research by the EditionID line, and pulls a column between the two columns, demonstrating the connection.

Inside part, you learned a different sort of way of incorporating the latest columns, written a calculated line playing with DAX, and put you to definitely column to ascertain a special matchmaking between tables. The fresh Servers dining table is becoming included in the info Model, as well as info is open to the fresh new PivotTable inside Sheet1. You may use the associated studies to produce a lot more PivotTables, PivotCharts, Strength View reports, and a lot more.

Carry out a hierarchy

Extremely Data Activities include study that’s naturally hierarchicalmon these include calendar investigation, geographic research, and you can device categories. Undertaking hierarchies within Strength Pivot excellent since you may pull one to items in order to research – the latest ladder – instead of having to collect and acquisition a similar areas more as well as.