Forum Discussion

manishbhamare97's avatar
manishbhamare97
Frequent Visitor
2 years ago

Need help in connecting two table in Power Bi

Hey Power BI community,

 

I need your help for below issue:

 

I have connected below 3 tables (Learning Hours, Daily Planning sheet, Employee 3i Data) with Emp Roll No table to connect employee roll no with other tables. But I want to filter my data by dates between table Daily Planning Sheet and Employee 3i Data, but I'm not able to establish a live connection between those two tables. Is there any other option with which I can filter the data of Table-Employee 3i Data by dates in Table-Daily Planning sheet ?

 

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • Vallirajap's avatar
    Vallirajap
    Icon for Resolver III rankResolver III
    2 years ago

    Hi manishbhamare97,

     

    Try this, 
    Change the cross filter direction between "Emp Roll No" and "Daily Planning Sheet" in Single to Both and apply changes, then check.

     

     

    Did I answer your question?

    Mark my post as a solution, this will help others...!

    Hit the kudo also,

    Thank you.

    • manishbhamare97's avatar
      manishbhamare97
      Frequent Visitor
      2 years ago

      Hi,

      Thank you for this. Yes, It filters the data, but whatever the data it filters as per date, is inaccurate as compared to original data.