Stretch the info Design having fun with calculated articles

Lượt xem:

Đọc bài viết

Stretch the info Design having fun with calculated articles

To connect Machines toward Data Design, we are in need of an industry with beliefs one to exclusively choose for every line about Machines desk. Then we can search our very own Studies Model to find out if one to exact same studies is present an additional table. Looking in the Diagram Look at doesn’t help us do that. Which have Hosts chosen, option returning to Study View.

Once examining the articles, we realize you to definitely Hosts does not have any a column of unique opinions. We’ll have to carry out it having fun with a computed line, and you can Studies Analysis Expressions (DAX).

It’s sweet in the event the studies in your Data Design enjoys all the newest sphere needed to create matchmaking, and you may mash upwards analysis to imagine when you look at the Strength View or PivotTables.

At the same time, that occupation have to correspond to an area about Analysis Design. People relevant areas, one out of for each and every desk, are just what allows the fresh new tables’ data become associated.

Given that Servers desk doesn’t have such as for instance an industry, you should manage it. In preserving the newest ethics of Investigation Design, you simply cannot use Power Rotate to help you change otherwise delete current investigation. You could potentially, however, would the columns that with computed areas in accordance with the existing data.

Of the appearing from Servers dining table, after that considering most other Study Design dining tables, we find good candidate for a new job we could carry out when you look at the Hosts, immediately after which relate with a table throughout the Investigation Design. Each other tables requires a new, calculated line to generally meet the requirements wanted to establish a relationship.

From inside the Hosts, we are able to do another determined line from the consolidating the brand new Edition community (the season of Olympics event) plus the Year job (June otherwise Wintertime). Regarding Medals table there is also a model job and you will a month community, therefore if we would a computed column in the each of those dining tables that mixes new Version and you will Seasons areas, we can expose a relationship between Servers and you may Medals. The second screen suggests the Computers table, having its Release and you can Year fields chose

To establish a love involving the Servers desk therefore the Studies Design, and you can and therefore offer the Investigation Model to incorporate the latest Hosts table, Machines have to have an area one exclusively identifies for every single line

Let us start with the fresh new Hosts desk. The target is to manage a determined line regarding the Servers table, and about Medals desk, which you can use to determine a love between the two.

Into the Strength Pivot, you are able to Research Analysis Phrases (DAX) to manufacture calculations. DAX was a formula words to have Electricity Rotate and you can PivotTables, available for the latest relational investigation and contextual data in Stamina Pivot. You may make DAX algorithms when you look at the a different sort of Power Rotate line, and in the newest Formula Urban area inside the Power Pivot.

Inside Power Pivot, see Home > See > Study Check to make sure Analysis Evaluate is chosen, unlike in Diagram Examine.

But dining tables commonly usually very collaborative, therefore the 2nd part means how to create a different sort of column, having fun with DAX, that can be used to produce a relationship ranging from tables

Find the Computers desk inside Power Rotate. Beside the present columns are a blank column titled Incorporate Line. Stamina Pivot brings one line just like the good placeholder. There are many an effective way to incorporate an alternative line to an effective table for the Energy Rotate, certainly one of that’s to only discover the empty column one has got the name Create Line.

Regarding the algorithm bar, sorts of the second DAX formula. The fresh CONCATENATE form combines several sphere towards that. Since you sort of, AutoComplete makes it possible to variety of the new completely certified names from columns and dining tables, and you will listing the fresh new features available. Have fun with case to pick AutoComplete recommendations. You could simply click the brand new column while you are typing their formula, and Power Pivot inserts new column identity into your algorithm.