We must locate them both, and construct a relationship

We must locate them both, and construct a relationship

Let’s rename the fresh new computed column in order to EditionID. You can rename one column because of the twice-pressing they, otherwise because of the correct-pressing new line and you can opting for Rename Line. Whenever finished, the newest Computers dining table in the Electricity Pivot turns out the following display screen.

This new Servers table is prepared. 2nd let us create a calculated line when you look at the Medals that matches brand new structure of your own EditionID line we established in Machines, therefore we dine app ne demek can create a love between them.

Begin by performing an alternate line regarding the Medals table, for example we did for Servers. Inside Power Rotate select the Medals dining table, and click Construction > Columns > Add. Note that Put Column is chosen. It offers an equivalent perception since merely finding Add Column.

We developed the EditionID column to act just like the Computers table first trick (novel, non-repeated occupation), and created an enthusiastic EditionID column regarding Medals desk to enable place regarding a love among them

The fresh Edition column within the Medals have a new style compared to Version column when you look at the Computers. Ahead of i mix, otherwise concatenate, new Version line on the 12 months line which will make the EditionID column, we must manage a mediator job that becomes Version on the best style. About formula club over the table, type of the second DAX formula.

After you end strengthening the latest formula, press Enter into. Values try inhabited for rows in the determined column, based on the formula your inserted. For folks who evaluate it line towards Version line into the Hosts, you will see that these articles have a similar format.

When you created a different sort of column, Strength Pivot extra some other placeholder column entitled Incorporate Column. Next we need to create the EditionID determined column, very look for Include Column. Regarding algorithm club, sort of another DAX formula and you can press Enter.

Notice of a lot values is actually constant about Medals dining table EditionID community. That’s okay and you can requested, just like the throughout for every single model of one’s Olympics (now portrayed because of the EditionID well worth) of several medals was indeed awarded. What exactly is unique from the Medals dining table are for each given medal. The initial identifier for each and every list regarding the Medals table, as well as designated number one secret, is the MedalKey community.

Regarding the Energy Pivot windows, look for Family > Check > Diagram Consider on bend. You could option between Grid evaluate and Drawing evaluate using brand new keys at the end of the PowerView screen, because the found from the following display.

Expand Servers so you can examine all of its industries. Fuel Pivot will bring a find feature on the ribbon, in order to search your data Model having related sphere. The next screen reveals the Get a hold of Metadata window, with EditionID entered regarding Select What community.

Pull the fresh EditionID line during the Medals into EditionID column for the Servers. Fuel Rotate brings a relationship amongst the tables based on the EditionID line, and you will brings a column among them columns, appearing the partnership.

Contained in this area, your read yet another technique for incorporating the fresh new columns, authored a computed column having fun with DAX, and made use of one to column to establish an alternative relationships between tables. Brand new Servers table became utilized in the details Design, and its info is available to the latest PivotTable in Sheet1. You are able to use the relevant analysis to help make even more PivotTables, PivotCharts, Fuel Consider account, plus.

Would a hierarchy

Most Data Habits is study that is naturally hierarchicalmon these include calendar study, geographical studies, and you may equipment classes. Performing hierarchies contained in this Strength Pivot excellent because you can pull you to goods to help you research – this new steps – in place of needing to collect and you can purchase an identical industries more as well as over.

Dejar un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *