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
Super UserSylwiaK , refer if this can help
Power Query Across Table calculated column: https://youtu.be/InjrmY-LJdA
Hi amitchandak,
thanks for the response, unfortunately it has the same result - cyclic references error
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