Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cross Table If Statements?

Hi All,  Only started with PowerBI last week so go easy on me!   I have tables like the below added:   Table A   ID Name 1 A 2 B 3 C   Table B   ID Model 1 8...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    1. Try Merge Queries like in the video below.
    2. Or if you wont to preserve the model and add columns from different tables use RELATED or RELATEDTABLE DAX functions.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

  1. Try Merge Queries like in the video below.
  2. Or if you wont to preserve the model and add columns from different tables use RELATED or RELATEDTABLE DAX functions.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski