Forum Discussion
Relationship issues part 2
Summarising should do the work, if you change the change datatype to text and there is multiple entries for same date, it can only show first or last value.
Hello CMSGuy
I have used the same dataset and relationship as you have provided. This shouldn't cause any issue for this requirement. Relationship is based on transaction date.
The date from the below table visual is from calendar table.
Please provide more information if you still feel the issue is not solvable.
Regards,
Naveen
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
I do have that extra relation in there of EmployeeID. I wonder if I removed that if it would "fix" the issue?
That should not be of any impact in the current context, as you are not using any columns from that table in the visual or filter, which might impact the underlying data for the three tables.
In recreating what you did using my datasets, I did find that the Ratings "number" is being summarized. When I clicked Do Not Summarize, I lost that other line of data. When I do summarize, it is there. Should I change those rating numbers into Text as they do not need any sums or calculations?
