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...
Some cosmetic in addition to Riny_van_Eekelen​ answer. I'd add actual dates to the data
and Date table to the data model
it gives more flexibility and reliability working with model. Don't forget to sort period (Date table) in proper order
and use it in PivotTable
Finally, Microsoft named product as "Power Pivot" but "PivotTable".