Forum Discussion
Target vs Actual
Hi All, I have 2 tables - 1 for Actual Sales from SAP BW, OTher is Targets in an Excel. We have targets by Region Level by SKU. I made a relationship btw 2 tables with a calc.column Region&S...
Never join two data tables together directly. Instead join to a common lookup table, where the lookup table has a superset of every value in the columns in the joins.
https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/
MattAllington
Community Champion
Community Champion
Never join two data tables together directly. Instead join to a common lookup table, where the lookup table has a superset of every value in the columns in the joins.
https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/