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.

     

mai_2020's avatar
mai_2020
Frequent Visitor
5 years ago

mwegener I do have a master data table which is not linked to dates table in any way. I was hoping that i could do it beautifully with calculated table, where all the possible id's will be assigned to a date. Sort of like

1/1/2021, id1, sales (from sales)
1/1/2021, id2, sales (from sales)

1/1/2021, id5, sales (from forecast)

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

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