To connect Servers towards Studies Design, we want an industry having viewpoints you to definitely exclusively choose per line in the Servers table. Following we could research the Studies Model to find out if that same investigation can be obtained in another table. Searching inside Drawing Consider does not allow us to do that. Having Servers selected, option back into Studies Consider.
Just after exploring the columns, we know you to definitely Servers has no a line from novel opinions. We’ll need certainly to manage they playing with a calculated column, and you may Studies Data Words (DAX).
It’s sweet when the analysis on the Investigation Model enjoys all the the brand new industries needed to create relationships, and mash up data to visualize during the Power Have a look at or PivotTables.
Additionally, one industry have to match an industry regarding the Analysis Design. Those associated areas, one out of per dining table, are what allows new tables’ studies to-be associated.
Since the Hosts table has no including an area, you should carry out they. To preserve the brand new stability of your Studies Design, you can’t play with Power Pivot in order to change or remove present research. You could, yet not, perform new articles by using determined sphere in accordance with the present studies.
From the lookin through the Machines desk, upcoming considering almost every other Data Model dining tables, we discover a beneficial candidate to have a different sort of career we can do inside Servers, immediately after which connect with a table regarding the Studies Model. Each other dining tables requires an alternate, calculated column to satisfy the needs wanted to expose a love.
Inside the Hosts, we could do another type of computed column by combining the Release community (the season of your Olympics experiences) and also the Season field (Summer or Winter). Regarding Medals dining table additionally there is an edition occupation and you will a period career, therefore if i carry out a determined line in the every one of those tables that combines the fresh Model and you may 12 months fields, we are able to establish a love ranging from Computers and you can Medals. Another monitor reveals this new Computers dining table, with its Edition and you can Seasons sphere chose
To establish a relationship involving the Servers desk and the Research Model, and and so stretch our Investigation Model to add the latest Computers desk, Hosts must have an area you to uniquely identifies for each line
Let us start by the brand new Servers table. The target is to would a calculated column on Computers desk, right after which regarding Medals desk, which you can use to determine a romance between them.
During the Electricity Pivot, you can utilize Study Analysis Terms (DAX) to create computations. DAX was an algorithm words to have Fuel Rotate and you may PivotTables, designed for the fresh relational analysis and you may contextual research obtainable in Power Pivot. You possibly can make DAX formulas within the a different sort of Power Pivot line, and also in the new Calculation Area during the Power Rotate.
In Strength Pivot, discover Household > Consider > Investigation Look at to be sure Study Consider is chosen, in lieu of staying in Drawing See.
However, tables are not always thus collaborative, therefore the second point means how to create an alternative line, playing with DAX, that can be used to create a love ranging from dining tables
Select the Servers dining fuck marry kill hesap silme table inside the Energy Rotate. Near the current articles is actually a blank column named Incorporate Line. Fuel Pivot will bring you to definitely line because the a great placeholder. There are numerous a method to include an alternate line to help you an excellent dining table when you look at the Strength Rotate, one of which is to simply get the empty column you to definitely gets the title Put Line.
On algorithm bar, sort of the next DAX algorithm. Brand new CONCATENATE means combines two or more areas into one. Since you variety of, AutoComplete helps you method of the new fully accredited brands regarding articles and tables, and lists the latest functions that are available. Fool around with tab to choose AutoComplete recommendations. It is possible to just click this new column when you’re typing their algorithm, and you will Stamina Rotate inserts the newest line term into your formula.