Forum Discussion
Sum Rows from Different Tables, Deduct from Start Value
Thank you so much, nearly there.
Because my Value Day1 data may have multiple rows that total the value, it appears to duplicate the Start Value when I merge using the double arrow.
So, in the sample for Project 12345, I might have 2 rows of data that equal the 1000 value (2 rows of 500 for that project on that day). The Power BI table auto sums for that Project, so Day1 does show 1000 which is great. BUT, the merge process seems to add multiple rows for the Start Value.
First image below shows the initial merge process where each company starts with 10000. 2nd image shows that it duplicates the value (multiple entires for some companies). When I add this to a table visualisation, it sums the totals, so Company 3 shows as 20000. If I change to 'dont Summarize', it alters the display of each entry back to 10000, but the new End Value still uses the 20000.
Merge Start
Merge after clicking double arrows;
Then either we are doing something a little bit differently in our examples or I'm not understanding yourdesired results. I added a duplicate value for project 12345 in Table2 with a Value Day 1 of 1000:
in my output visuals i have all values set to not summarize. You'll see that I only have one entry in table2 for project 12345 with a value day 1 of 1000 (not 2000). In my merge1 table it used the 1000 in value day 1 and 2 to calculate my end value (10000 - 1000 - 1000 = 8000). What am I missing?