Forum Discussion
Solved
Join 2 tables based on multiple conditions
Hi community, I am fairly new to Power Query and can't figure out how to translate this sql into a power query. I can't do an sql query, as I transform the table once it is in Power BI and only t...
- So, you could create a column in both tables that concatenate the fields to join on?
So, you could create a column in both tables that concatenate the fields to join on?
Hi Greg,
you were right. I managed to join the tables with calculated columns checking for my conditions and removing the rows that are useless.
e.g. column: timestamp - start. That column is filtered only for positive values.