Forum Discussion

topazz11's avatar
topazz11
Helper III
2 years ago
Solved

Combining multiple table with date

Hello,   I have 3 tables which contains similar data with month/year and some blank/zero value. I'd like to combine them as single table.   What is the best way to achive this?   Thanks,   ...
Need Help
  • vicky_'s avatar
    vicky_
    2 years ago

    You can either merge queries (2x) in PowerQuery, or you can try create a table with DAX. Something like:
    CombinedTable = ADDCOLUMNS(Table1, "Actual1", RELATED(Table2[Actual1]), "Actual2", RELATED(Table3[Actual2]))

     

    (the above dax would only work if there's a relationship between the date columns)

vicky_'s avatar
vicky_
Super User
2 years ago

You can either merge queries (2x) in PowerQuery, or you can try create a table with DAX. Something like:
CombinedTable = ADDCOLUMNS(Table1, "Actual1", RELATED(Table2[Actual1]), "Actual2", RELATED(Table3[Actual2]))

 

(the above dax would only work if there's a relationship between the date columns)