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.
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.