I am not clear about logic of calculation, so if possible, coud you please explain this to me more details?
How did you calculate Total Production, sum monthly based on daily table? Why only 2A and B location in Table, how did you choose this? I need to understand your logic, then I will help you more correctly.
Yes, that's right. It is a sum of production for each Location each month from the Daily Table.
Location A has total production = 105 in January 2019 (2019-01), and 88 in December 2018 (2018-12).
While Location B has total production = 82 in January 2019 (2019-01).
Daily Table only shows the illustration of the data structure, and not intended to show all data (to make it short)
So, if Location B apparently has production in December 2018 and/or moving forward, the result is expected to have the sum of production in each respective month for Location B. This is to be applied for Location A as well.
If I understand correctly from your file, Table Location Guarantee is expanded to each day by adding a Custom Column in Query Editor. Just wondering, is there an alternative to use DAX formula for this same purpose?