Forum Discussion

davijs's avatar
davijs
Regular Visitor
8 years ago
Solved

Join Calculated tables DAX

Hi -      I am trying to Join 3 calculated tables, each with information about defects on an Application/Function, where the lookup table (Application Inventory) is related to each table, but it is...
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    OK, what I would suggest is that you use an Append query to append all 3 of your tables together. You could add a column in each one of them to tell you where it came from, just create the same column in all three source queries with the same column name and give them a static value of "Open", "Closed", etc. 

     

    I think then your problems will become far easier and almost trivial at that point.

davijs's avatar
davijs
Regular Visitor
8 years ago

BTW - 

 

Below is the model for the source data:

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

OK, what I would suggest is that you use an Append query to append all 3 of your tables together. You could add a column in each one of them to tell you where it came from, just create the same column in all three source queries with the same column name and give them a static value of "Open", "Closed", etc. 

 

I think then your problems will become far easier and almost trivial at that point.