Table relationship not working

[AndrewX]

I have a simple setup, 1x csv called costs, 1x csv called orders.

I added them to the data model, and made a relationship on the product column.  I then created a powerpivot table and was hoping to sum the costs by product and/or name, but it wont calculate properly.  

Any clues?

Not calculating properly

Even though it is complaining about the relationship, i have already set that up.

  

[#2 · Accepted solution]

I found the solution in another post here https://techcommunity.microsoft.com/t5/excel/date-relationship-in-power-pivot-not-recognized/m-p/325...