We have to locate them each other, and construct a romance
Why don’t we rename the determined column to EditionID. You can rename one column because of the double-clicking they, or by the proper-pressing the line and choosing Rename Column. Whenever finished, the fresh Computers desk when you look at the Fuel Pivot ends up another monitor.
The brand new Machines table is ready. 2nd let us carry out a calculated column when you look at the Medals which fits the structure of one’s EditionID line i established in Hosts, so we can create a romance between the two.
Begin by performing a new column regarding the Medals dining table, like i performed to own Servers. Inside the Strength Rotate select the Medals desk, and click Framework > Articles > Put. Notice that Add Line is chosen. This has an identical impact given that only interested in Create Line.
We created the EditionID column to behave just like the Computers dining table top trick (unique, non-regular profession), and you may written an EditionID line from the Medals desk allow facilities away from a love between the two
Brand new Version column within the Medals provides another structure compared to the Model column in Machines. Before we merge, otherwise concatenate, new Release line on Year line which will make the new EditionID line, we must would an intermediary profession you to becomes Version on the suitable format. Regarding algorithm club over the desk, kind of the next DAX algorithm.
Once you end up strengthening the fresh new algorithm, push Get into. Opinions is actually populated for all the rows about calculated line, in line with the formula your entered. If you evaluate this column into the Version line inside the Computers, you will see these articles have the same style.
Once you written a different line, Stamina Pivot additional another placeholder column titled Incorporate Line. 2nd we would like to produce the EditionID computed line, thus come across Include Line. On formula club, sorts of another DAX formula and you can press Go into.
See of a lot values was frequent on the Medals desk EditionID career. Which is ok and you may expected, since while in the for each release of your own Olympics (now portrayed by EditionID value) of a lot medals have been approved. What is actually novel regarding Medals desk is actually for each and every awarded medal. The initial identifier per list throughout the Medals desk, and its designated primary trick, ‘s the MedalKey occupation.
About Stamina Rotate windows, discover Domestic > Examine > Diagram Check regarding ribbon. It’s also possible to option ranging from Grid view and you will Drawing check having fun with the brand new buttons at the end of your PowerView window, because shown about pursuing the monitor.
Build Computers to help you take a look at every one of their areas. Energy Pivot will bring an observe ability for the bend, so you’re able to browse your computer data Design getting associated sphere. The second monitor suggests the newest Find Metadata screen, having EditionID registered regarding Select What job.
Drag the EditionID line within the Medals into EditionID column inside the Computers. Electricity Rotate brings a relationship between your tables according to research by the EditionID column, and you can brings a line between the two articles, demonstrating the relationship.
Contained in this section, you read a different way of adding the fresh new columns, composed a computed line using DAX, and made use www.datingranking.net/tr/chatki-inceleme of that column to ascertain a different sort of matchmaking ranging from dining tables. The fresh new Hosts dining table is starting to become utilized in the details Design, as well as information is open to the latest PivotTable into the Sheet1. You can also use the associated analysis to create even more PivotTables, PivotCharts, Energy Take a look at account, and much more.
Create a ladder
Very Investigation Models become study that’s inherently hierarchicalmon for example calendar data, geographical research, and you can equipment groups. Creating hierarchies inside Stamina Pivot is useful as you may pull that goods to a report – the latest hierarchy – in lieu of being forced to gather and you can acquisition a comparable areas over and over.