Forum Discussion
summarizing multiple values from different Table within other Table
Hi Anonymous ,
You can try this code to create a calculated column in second table.
Column = CALCULATE ( SUM ( 'First Table'[Final cost] ), FILTER ( 'First Table', CONTAINSSTRING ( 'First Table'[Search value], 'Second Table'[Info] ) ) )Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , Not very clear a new column in table 1
Maxx(filter(Table2, Table1[Search value] = Table2[Info]) , Table2[final Cost])
If this does not help
Can you a sample output in table format?
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Hi amitchandak,
apologize for not beeing clear enough.
i do build the table in Word, now it also contains the border to make it more clear
the second table contains the "Info" i do need to search in the first table in the column "search value" and it shoud Summarize all the "final cost" from the first table and it should be on the second table in column "Final cost - summary" available.
First table
Search value | Cost A | Cost B | Final cost |
1Z32sde
| 12 | 32 | 44 |
1z8432 | 12 | 23 | 11 |
1zwert32456 | 12 | 27 | 15 |
1z098761 | 43 | 2221 | 554 |
1z32sde | 22 | 123 | 456 |
In General text-number mix |
| 123 | In general a formular calculating different values based on other criteria |
Second Table
Info | Final cost - summary |
1Z32sde
| 500 |
1zwert32456 | 15 |
1z098761 | 554 |
1Z32sde
| 500 |
|
|
so for the value "1Z32sde" it would deliver 50 as feedback as in the first table are "2" values available summarized together as 500.
i hope that helps.
p.s. thanks for the max formular. I do wish power bi would work on mac as well. Then i would be able to play and increase my knowledge in my free time, too.