Forum Discussion

mai_2020's avatar
mai_2020
Frequent Visitor
5 years ago
Solved

Combining columns from different tables with DAX

Hi everybody,   I am not sure if this is possible, but i have a Dates table, Actuals and Forecasts. Within actuals and forecast table i have some master data(like id). Actuals and forecasts are not...
Need Help
Show and Tell
Tutorial Requests
  • mwegener's avatar
    mwegener
    5 years ago

    Hi mai_2020 ,

     

    all filtering/categorizing columns must be linked in both tables via a common (Dimensions) table.
    I think in this case the ID column will be the problem.
    Can you merge the two tables into one table?

     

  • mwegener's avatar
    mwegener
    5 years ago

    mai_2020 if possible, I would recommend you to solve it with PowerQuery.
    This is the more efficient solution.

     

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hi mai_2020 ,

 

all filtering/categorizing columns must be linked in both tables via a common (Dimensions) table.
I think in this case the ID column will be the problem.
Can you merge the two tables into one table?

 

  • mai_2020's avatar
    mai_2020
    Frequent Visitor
    5 years ago

    This turned out to be the most practical solution for me:)