Forum Discussion
How to joint two tables based on values
Managed to figure out how to solve the problem - used the solution by amitchandak but had to change type of data to numeric and then it compared the values correctly
amitchandak I tried one more time following your tutorial and it almost works 😉
The problem is that the values of columns are not compared, i.e.:
= Table.AddColumn(#"Changed Type", "Custom", each let
col = [Beginning],
_table = Table.SelectRows(glds_export, each [END] <= col),
count = Table.RowCount(_table)
in
count)
results in all rows selected...
Three columns are of the type Date/Time.
Would you have any idea how to cope with that?
Managed to figure out how to solve the problem - used the solution by amitchandak but had to change type of data to numeric and then it compared the values correctly