Direct Query Compare two Columns from different tables

[Anonymous]

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?

[amitchandak]

@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=czNHt7UXIe8

All these examples use one column, but in case of maxx, minx you can have more than one condition in filter