Future position with the data require an alternate cardinality

Future position with the data require an alternate cardinality

To produce the fresh dating

In the Create matchmaking, pick New to open new Perform matchmaking dialog package, where we are able to select the dining tables, columns, and you may any extra configurations we want for the relationships.

In the first miss-off listing, find ProjectHours due to the fact first dining table, next discover the Investment line. That it top is the of many edge of our matchmaking.

About 2nd shed-off listing, CompanyProject was preselected since the next desk. Find the ProjName column. Which https://datingservicesonline.net/tagged-review/ front is certainly one edge of our matchmaking.

For the sake of complete revelation, you just authored that it dating the hard method. You can get only selected Autodetect on Manage relationships dialogue container. Indeed, autodetect might have immediately created the dating for you once you loaded the details in the event that both articles had the same identity. However,, what’s the complications for the reason that?

Once we summarize hours because of the Concern, Fuel BI Desktop computer looks for the instance of exclusive color philosophy on the CompanyProject research dining table, looks for all instance of every one of those individuals opinions from the ProjectHours desk, then works out a sum total for every single novel value.

Knowledge additional options

Whenever a romance is created, often with autodetect otherwise you to definitely you make manually, Power BI Desktop instantly configures other choices based on the study on the dining tables. These types of a lot more matchmaking options are found in the down percentage of the newest Manage dating and you will Change relationships dialogue packets. (más…)