Forum Discussion

RickardBengzon's avatar
RickardBengzon
Frequent Visitor
4 years ago
Solved

SUM values in one table from another table

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?    
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    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.

Schwadenfeld's avatar
Schwadenfeld
Helper I
3 years ago

same issue here, any solution? 🙂 thanks!