cancel
Showing results for
Did you mean:
Frequent Visitor

## "VLOOKUP" 2 Tables

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Member

## Re: "VLOOKUP" 2 Tables

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.

2 REPLIES 2
Highlighted
Member

## Re: "VLOOKUP" 2 Tables

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.

Frequent Visitor

## Re: "VLOOKUP" 2 Tables

Many Thanks!!

Announcements

#### New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

#### November 2019 Community Highlights

Get an overview of the events and great community content from November.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)