Summarize table

[Anonymous]

Hi

I am new to PBI, and I need to calculate a column, or make a new table where I can see infomration of 2 tables:
I have a table called 'CLIENT 'where existe the column [ID_CLIENT], it has unique data,

and I have a second table called' DELIVERY ', where I have the same column [ID_CLIENT], but in this table I have information from many more customers.

How can I  get only  the information that is on the 'DELIVERY¨ table, but only the customers of the tabala' CLIENT' only,

How I can remove the second table´s information acording to the clients I have in the first one

Here is an example: 

 'CLIENT 

ID_CLIENT	IV	FV
102318	9:00:00	17:00:00
108439	8:00:00	16:00:00
101174	8:00:00	12:00:00

'DELIVERY´

ID_CLIENT	Delivery Hour
102318	10:00
108439	11:00
101174	13:23
101145	12:00
101243	12:00
102318	11:00

Create a table only with the info in Bold

Thanks!

[anandav · Accepted solution]

@Anonymous,

Establisg a 1:many relationship between Clinet and Delivery table using Client ID column.

Then create a new table (Modelling -> New Table) using:

New Table =
Var t1 = DISTINCT(Client[Clied_ID])
RETURN
NATURALINNERJOIN(t1, Delivery)

If this solves your problem please mark as the solution.

[GilbertQ]

Hi there,

What I would do is to create a relationship between the two tables on the ID_CLIENT

Then I would create a new table from DELIVERY.
Next I would then create a calculated column using the RELATED function to bring across the IV and FV columns.