Forum Discussion

jwbtkd3's avatar
jwbtkd3
Frequent Visitor
9 years ago
Solved

IF Function - return values from one table if true, values from other table if false

Hello,   I have slowly been learning Power BI and this issue I am working on has plagued me for some time now. These are reports that are being pulled a weekly basis for visibility inside my Firm. ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi jwbtkd3,

     

    I've modified your PBIX file and here is the output.

     

    The idea is to Merge the three tables together using the Query Editor.

     

    PBIX File

     

    The table you are looking for is the one called Final

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi jwbtkd3,

 

I've modified your PBIX file and here is the output.

 

The idea is to Merge the three tables together using the Query Editor.

 

PBIX File

 

The table you are looking for is the one called Final

jwbtkd3's avatar
jwbtkd3
Frequent Visitor
9 years ago

This works like a charm. Awareness of conditional columns would have helped me greatly, but organizing the data was key, too. Thank you for your help :)