Forum Discussion
AndrewX
Feb 16, 2023Iron Contributor
Table relationship not working
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.
I found the solution in another post here https://techcommunity.microsoft.com/t5/excel/date-relationship-in-power-pivot-not-recognized/m-p/3250155
- AndrewXIron Contributor
I found the solution in another post here https://techcommunity.microsoft.com/t5/excel/date-relationship-in-power-pivot-not-recognized/m-p/3250155