SUM values in one table from another table

[RickardBengzon]

I have two tables. They are connected by date. And Date in table one is Unique.

I want to sum the values from table2 two in a column in table one.

Any tips?

[Schwadenfeld]

same issue here, any solution? 🙂 thanks!

[v-xiaotang · Accepted solution]

Hi @RickardBengzon 

Try this,

Sum of Value = 
    var _value = CALCULATE(SUM(Table2[Value]),FILTER(ALL(Table2),Table2[Date]=MIN(Table1[Date])))
return IF(ISBLANK(_value),0,_value)

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@RickardBengzon 
Add the following column in Table 1

Total = CALCULATE ( SUM ( Table2[Value]) )

[RickardBengzon]

I don't get any result from that If I remove "CALCULATE" and only use sum I get the total sum of all value for all dates

[Fowmy]

@RickardBengzon 

Please try this:

Total = 
SUMX( 
    FILTER( Table2 ,  Table2[Date]  = Table1[Date] ),
    Table2[Value]
)

[RickardBengzon]

Seems legit but still doesn't work. I get no values at all... Thinking if there is somethings wrong with the date-connection... But they both seeem to be the same...