Forum Discussion

ShreySharma's avatar
ShreySharma
Frequent Visitor
2 years ago

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 ...
Need Help
ShreySharma's avatar
ShreySharma
Frequent Visitor
2 years ago

Thanks for this Anonymous. I used the formula to create a new column, however, when I try and expand the column to get the columns from Table 2, I always get an error "No columns were found"

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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.