Forum Discussion
Join table with several columns and condition
Hello everyone, I am facing a special case with Power BI Desktop. Here is the situation, I have two tables with some columns : +--------------+ +--------------+ | ...
Up
Does someone have an idea ? I'm still searching on the net but I can't find how to join the tables...
I'm on an idea currently. The idea is merging the two table (left join), and then apply a filter to fulfill the condition (a date between the two others). I can merge the table via edit queries, but how to apply the filter then ?