"VLOOKUP" 2 Tables

[RMSLUIS]

Hi everyone,

I need help to solve this problem....Basic problem, I think. 

Basically, I have 2 tables and need, in the first one, to sum the values of 1 colum from the another table, gruped by user, which is the Key...

Example:

Thanks,

Rui Luis

[ZunzunUOC · Accepted solution]

Hi @RMSLUIS ,  you can create the next calculated column:

Total Burned Points = 
var iduser= Users1[User ID]
return
CALCULATE(SUM(Users2[Points Burned]);FILTER(users2;Users2[User ID]=iduser))

Care with the option "don't summarize" is active and use your name tables.

Result:

Best Regards,
Miguel

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

[RMSLUIS]

Many Thanks!!