Daily Variance between 2 different sheets

Question

I receive daily excel outputs from a db containing customer order details. The daily excel sheet contains a snapshot of the remaining product value to be shipped to each customer but doesn't identify the change. &nbsp;I want to represent this within power bi, showing the start figure on day 1, the figure on day 2 and the variance. Because I receive the data in a separate table each day, I want to somehow combine and detail the differences. &nbsp;Example below shows the start values to ship on day, then the current value on day (on a different sheet/table), showing that we shipped 3000 of product 1, nothing for product 2, and 500 for product 3. I want to represent this in a table/matrix in BI, the customer, day 1 value, day 2 value, variation change.Day1Customer &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Product 1&nbsp; &nbsp; &nbsp; &nbsp; Product 2 &nbsp;&nbsp;&nbsp;&nbsp;Product 3Abc customer &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1000Day 2Customer &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Product 1&nbsp; &nbsp; &nbsp; &nbsp;Product 2 &nbsp;&nbsp;&nbsp;&nbsp;Product 3Abc customer &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;500Output Required&nbsp;Customer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Day 1 Product 1&nbsp; &nbsp; &nbsp; &nbsp;Day 2 Product 1&nbsp; &nbsp; &nbsp; Variance Prod 1&nbsp; &nbsp; &nbsp; &nbsp;Day 2 Product 1&nbsp; &nbsp; &nbsp; Day 2 Prod 2&nbsp; &nbsp; Variance Prod 2...&nbsp;Abc customer&nbsp; &nbsp; &nbsp; 5000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -3000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;&nbsp;Hope this makes sense.

anonymous · Answer

Hi Newbie_77&nbsp;Please share some data and the poutput desired in OneDrive or GoogleDrive and provide the link here to find a solution.&nbsp;Cheers&nbsp;CheenuSing

Forum Discussion

Daily Variance between 2 different sheets

1 Reply

Related content

Budget, actual and variance matrix

Variance bar chart

Presenting differences/variances in one table

Different schema into different destination

Stacked bar charts with variance