Forum Discussion
Merge 2 tables with Power BI Desktop
Hi ShreySharma
Did your table name is the same as i provided? the step i proveded, its table name is 'Table 2' .
Table.SelectRows(#"Table 2"（it should be your table name of the second table),(x)=>x[Employee ID]=[Employee ID] and x[Start Time]>=[Start Time] and x[End Time]<=[End Time])the did you add the custom column in table1? can you provide the step you created, the code can work in my sample, or your colum name is the same as i provided?
Best Regards!
Yolo Zhu
Thanks for the quick response Anonymous . Yes, I am using the same column headers, however, still getting the same error. Here is the link to the .pbix file. https://1drv.ms/u/s!Agm6iBywR0VNjkzUwH-gqcl7xkoO?e=IxPeUD
Hi ShreySharma
Try to change the code to the following
Table.SelectRows(#"Table 2",(x)=>x[#"Employee ID "]=[#"Employee ID "] and x[#"Start Time "]>=[#"Start Time "] and x[End Time]<=[End Time])Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous - No luck. Still the same error. No columns were found.