Forum Discussion
PowerPivot not returning correct data
Hello, In the following link you will find a PowerPivot that is referencing 2 specific tables with Inv# being the common field between the 2 tables. The PowerPivot is bringing in Troy Ounces and Rev...
Kindly ignore Kidd_Ip​ 's AI generated answer.
Just use the Month and Invoice number fields from the 1-side of the relationship and then it will work as you expect.
https://onecom5409298.sharepoint.com/:x:/g/EUjiPZibwUBBgmIRbXMUIRABXdytx63J1VbZ1WTQhvEFSw?e=6uc8Qb