Forum Discussion
Match Data in Power BI Desktop
Hello Guys, I am new using power bi, and need to relate two tables that share a common column ("Clients"), it means, data with the same information My problem is that in one column I have 10 di...
Ashish_Mathur
Super User
Super UserHi,
I am sorry but i cannot understand why the answer should be 8:30 and 11:00. Please explain.
Hi,
Sorry, the 2 datasets looks like these:
Dataset 1:
| Client | IVR_1 | FVR_1 |
| 100012 | 8:30:00 | 11:00:00 |
| ... | ... | ... |
Dataset 2:
| Client | Delivery hour |
| 100012 | 16:51:29 |
| .. | ... |
And the result would look like this:
| Client | Delivery hour | IVR_1 | FVR_1 |
| 100012 | 16:51:29 | 8:00:00 | 16:00:00 |
| ... | .. | ... | ... |
- Ashish_Mathur
Hi,
So when the client ID in Table 2 matches the client ID in Table 1, you want to extract the IVR_1 and FVR_1 from Table 1. Am i correct? If yes, then share a dataset (which i can paste into MS Excel) with matching clinet ID's in both tables.
Hi,
Yes, you are correct, i need the exact thing
Can you give some mail address, cause the data is too big it does not allow me to paste
Or how can I share the datasets with you?
- Ashish_Mathur
Hi,
Upload the file to Google Drive/One Drive and share the download link here.