Forum Discussion

sprotson's avatar
sprotson
Helper I
5 years ago
Solved

Merge/Lookup Using Conditions

I am a complete newbie to Power BI but have some limited SQL knowledge, so please bare with me   My scenario is as follows   Table1 contains a column called type (1,2,3 etc) Table2 contains 3 co...
Need Help
  • edhans's avatar
    edhans
    5 years ago

    sprotson The way to do this is to

    1. Filter your first table for the the condition you want.
    2. Then merge to the other table.

    If you don't want your first table permenantly filtered this way, create a reference to it, then do the merge with your 2nd table to the referenced query.

     

    If you would like more help, please give us some actual data so we can work through the code and show you what to do.

     

    How to get good help fast. Help us help you.
    How to Get Your Question Answered Quickly
    How to provide sample data in the Power BI Forum