To connect Computers with the Analysis Design, we truly need an area which have values one to distinctively choose for every single row throughout the Hosts desk. After that we could lookup our very own Investigation Model to see if that exact same study is obtainable in another desk. Appearing when you look at the Drawing Glance at cannot allow us to accomplish that. That have Hosts picked, button back into Investigation Check.
After examining the columns, we realize one to Hosts doesn’t have a line away from unique philosophy. We shall need to create they playing with a determined column, and you can Analysis Data Terms (DAX).
It is nice in the event the data on the Investigation Design has actually all of the the latest fields must perform relationship, and you can grind up study to imagine from inside the Strength Consider or PivotTables.
At the same time, one to career must match an industry about Investigation Design. People related fields, one out of for every desk, are just what allows new tables’ analysis getting related.
Just like the Computers table has no such as for example an area, you really need to manage they. To preserve the new integrity of the Investigation Model, you can’t explore Energy Pivot to modify or remove established investigation. You could potentially, however, manage this new articles https://datingranking.net/tr/be2-inceleme/ that with calculated areas based on the existing studies.
Because of the searching from the Hosts table, up coming considering almost every other Investigation Design tables, we discover a good applicant to possess a separate profession we can carry out during the Hosts, and relate to a table on the Investigation Design. One another tables will require a unique, calculated column to get to know the requirements necessary to introduce a love.
Within the Hosts, we can do a different sort of determined line by combining the brand new Version community (the season of the Olympics experiences) therefore the Seasons job (June otherwise Cold weather). About Medals desk there is a release occupation and you can a month field, anytime i do a computed column in the each of those dining tables that mixes the latest Model and you will Seasons industries, we can expose a romance anywhere between Computers and you may Medals. Next screen suggests the fresh Hosts table, with its Model and you may Year sphere chosen
To ascertain a romance amongst the Machines desk while the Analysis Design, and you will thereby continue our very own Data Model to add the Servers dining table, Machines have to have a field you to definitely exclusively describes each row
Let us start with new Machines desk. The aim is to perform a calculated line on Servers dining table, then regarding Medals desk, which can be used to establish a relationship between them.
Inside Electricity Rotate, you can use Investigation Analysis Terms (DAX) to manufacture calculations. DAX try a formula vocabulary to possess Strength Pivot and PivotTables, designed for brand new relational research and you may contextual research found in Stamina Rotate. You possibly can make DAX formulas inside a unique Stamina Rotate column, and in the Calculation Area when you look at the Fuel Rotate.
During the Stamina Rotate, select Domestic > Examine > Data Take a look at to make certain Study Look at is chosen, in lieu of being in Diagram Consider.
However, dining tables aren’t constantly very collaborative, so that the second section means how to create a unique line, having fun with DAX, which can be used to create a romance anywhere between tables
Get the Servers table in Energy Rotate. Next to the existing articles try a blank line called Incorporate Line. Energy Rotate brings that column just like the a placeholder. There are numerous an easy way to include a unique column so you’re able to a great desk into the Electricity Rotate, among which is to only discover blank column you to definitely contains the label Create Line.
About formula pub, sorts of next DAX algorithm. The brand new CONCATENATE means combines two or more areas toward one to. As you type of, AutoComplete can help you sort of the newest totally licensed labels regarding columns and you may dining tables, and you may listing this new properties that exist. Fool around with loss to pick AutoComplete recommendations. You are able to follow on new line when you are entering your own formula, and you will Stamina Rotate inserts the brand new line name to your formula.
Comentarios recientes