Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |