Let us rename the new calculated line in order to EditionID. You could potentially rename any column because of the twice-clicking it, otherwise by the proper-pressing new line and you will opting for Rename Column. When complete, the new Machines table in Strength Pivot turns out the next monitor.
This new Computers desk is ready. Next why don’t we manage a computed line inside the Medals which fits the brand new style of one’s EditionID column i established in Computers, therefore we can make a love between them.
Start with performing a new column regarding the Medals dining table, eg we performed to have Hosts. In the Power Pivot discover Medals table, and then click Build > Columns > Create. Note that Create Column is chosen. It’s a similar impact while the simply interested in Include Line.
I developed the EditionID line to act while the Computers desk no. 1 key (unique, non-constant field), and you can composed an EditionID column throughout the Medals dining table to enable facilities away from a romance among them
This new Model line when you look at the Medals have a different style compared to the Edition line inside the Computers. Ahead of i blend, or concatenate, brand new Version column into the Season line in order to make the fresh new EditionID line, we need to perform an intermediary industry one to becomes Version for the the right format. From the formula pub over the dining table, type another DAX algorithm.
After you end up strengthening the brand new algorithm, force Go into. Beliefs try populated when it comes to rows on computed column, according to the algorithm you registered. If you contrast which column on Release line from inside the Servers, you will notice that these columns have the same format.
After you written a different sort of column, Stamina Rotate added some other placeholder line called Add Column. 2nd we should create the EditionID computed line, very get a hold of Add Column. On formula pub, type of the following DAX algorithm and you will force Enter into.
Find of many viewpoints are regular on Medals dining table EditionID industry. That is ok and you may asked, just like the through the for each release of your Olympics (now represented by the EditionID well worth) of a lot medals was in fact given. What is actually book regarding the Medals desk is actually for each and every provided medal. Exclusive identifier for every single listing from the Medals dining table, and its particular designated no. 1 secret, ‘s the MedalKey profession.
In the Electricity Pivot window, select Home > Evaluate > Diagram Consider on the ribbon. You may also key anywhere between Grid have a look at and you may Drawing glance at playing with the newest buttons towards the bottom of your own PowerView windows, while the revealed on the following the display screen.
Expand Computers so you can glance at each one of their sphere. Fuel Rotate brings a notice element on bow, to help you search important computer data Design to have involved areas. The second monitor suggests brand new Get a hold of Metadata window, with EditionID joined throughout the See Exactly what field.
Pull this new EditionID line in Medals on the EditionID column in Servers. Stamina Rotate produces a romance amongst the dining tables in accordance with the EditionID column, and draws a line between the two articles, exhibiting the partnership.
Inside point, your learned another type of way of including the brand new columns, composed a computed line having fun with DAX, and utilized one to column to determine a different sort of matchmaking ranging from dining tables. The new Machines table is actually incorporated into the details Model, and its info is available to the new PivotTable when you look at the Sheet1. It’s also possible to utilize the related research to create additional PivotTables, PivotCharts, Electricity Check accounts, https://www.datingranking.net/tr/blackpeoplemeet-inceleme/ and a lot more.
Carry out a hierarchy
Very Study Models are analysis that is inherently hierarchicalmon examples include diary research, geographical studies, and product classes. Creating hierarchies contained in this Stamina Pivot excellent because you can pull that goods to a study – the newest ladder – instead of having to assemble and you will buy the same sphere more and over.
Recent Comments