Forum Discussion
Summarize table
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 uniq...
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.
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.
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.