Forum Discussion
PowerPivot-Create (from existing table) unique ID table/formula (multi columns) for m2m relationship
I would please like some advice or other suggestions as to what would be the best solution for this problem. I've posted in StackOverflow as well: https://stackoverflow.com/questions/66243432/power-p...
do you have sample of both the sales and the stock files with a few lines some with matching sites and barcode and some that does not match.
" Columns that need to match between the Stock and Sales data are Site and Barcode."
it sounds to me that you need to do a:
SUMIF StockTable[Site] = SalesTable[Site]
AND StockTable[Barcode] = SalesTable[Barcode]
in power query to normalize your data model and get a SUM of Total Sales from both files. Does that sound about right?