Forum Discussion
How to Check Relationship Accuracy
If it's one to one relationship, you really have nothing to worry about. Unless you are relating seemingly related column without any actual relationship. But that's bit hard to test.
How is index from one table tied (related in terms of data) to the other? Is it based on dates/time period? Or some other criteria?
I have a list of individuals for placement where some leave and some enter, but mostly it stays the same. I have compiled all of these into a total sheet called "Sheet 1" (I would rename it but it's already in PBI). I have another sheet with just TOTAL COSTS per expenditure (clothing, education, etc), which is FY 18. These are connected solely through Index columns I created (see first picture). I just don't see how PBI can take things so seemingly incongruent and create a relationship with so little data.
? I'm a bit confused now. So there is no actual relationship between two index columns (i.e. it's not primary and foreign key?).
Then relationship, really does nothing, unless you are trying to filter one table based on selection in the other table vice versa.
Ex: If you use DAX measure to calculate value on one table based on filter applied to the other table etc.
Hard to say what exactly is going on without looking at your model.