Forum Discussion
Direct Query Compare two Columns from different tables
Hey there,
I have the following Problem:
I have a PowerBI dataset imported via direct Query and habe some local excel tables imported via excel import.
Now i have to connect two columns form two tables:
Table 1: Imported via direct Query
| starttime | Order_Label | Downtime Reason |
| 28.01.2022 16:19 | 45812500 | Swap |
| 28.01.2022 14:42 | 45812500 | Swap |
| 28.01.2022 12:00 | 45812500 | Swap |
Table 2: imported via excel
| Date & Time | Smeltery | Coilnumber | TimeList |
| 28.01.2022 16:30 | 934300 | 789654 | 28.01.2022 16:18 |
| 28.01.2022 16:30 | 934300 | 789654 | 28.01.2022 16:19 |
| 28.01.2022 14:50 | 874547 | 745214 | 28.01.2022 14:42 |
| 28.01.2022 14:50 | 874547 | 745214 | 28.01.2022 14:43 |
| 28.01.2022 11:40 | 254124 | 748231 | 28.01.2022 12:00 |
Now i need to connect the Order_label to the smeltery Coilnumber and Date & Time
Therefor i added in PowerQuery a Colum TimeList, where every Value -30min to +30 min of the Date & Time Colum exists in 1 min steps.
Now i'm stuck how do i connect my two tables?
1 Reply
Anonymous , Means both are imported then it is as good as import
In power query , you need to check
https://www.myonlinetraininghub.com/excel-power-query-vlookup
In Dax you can use Maxx, sumx
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8All these examples use one column, but in case of maxx, minx you can have more than one condition in filter
