Forum Discussion
Merge 2 tables with Power BI Desktop
Hi All, I am trying to merge two tables within Power BI; however, I am not getting the correct result. First data set has the total time spent by an agent on a particular activity during the ...
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.