Forum Discussion
Solved
Conditional joins
Hi, I'm new to using power bi and usually work with SSMS. Hoping to find out if what I want to do is possible in power bi. I think it's best if I use an example. Table1 columns: StartDate, EndDa...
Hi Kenneth_37 ,
Check the following steps in Power Query Editor.
Step1# Inner join merge table1 and table2 with [Ward] and expand tables.
Step2# Create a custom column with below query:
Column = if [Table2.Date] >= [StartDate] and [Table2.Date] <= [EndDate] then 1 else 0Step3# Filter table with column = 1.
Result would be shown as below:
Then you can delete and rename the rows if you need.
Pbix as attached.
Best Regards,
Jay
Hello Kenneth_37
You can join both the tables based on the ward and provide the start and end date slicer.