Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Additional columns in DAX generated table

Hi,   I have two DAX generated tables with two columns (CustomerID, YearMonth).    Table A - generated using SUMMARIZECOLUMNS to get CustomerID and YearMonth to track active customers for each ye...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Why do you need calculated tables at all?  Can't you just have Date, Customer, and Location tables in your model and get your result with measures alone?  In any case, to answer the questions, more info needed on the table holding the location data.  If there is a relationship to the location/customer table, you can add a calculated column and use RELATED to bring it over.  If no relationship, you could use LOOKUPVALUE.

    Regards,
    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Why do you need calculated tables at all?  Can't you just have Date, Customer, and Location tables in your model and get your result with measures alone?  In any case, to answer the questions, more info needed on the table holding the location data.  If there is a relationship to the location/customer table, you can add a calculated column and use RELATED to bring it over.  If no relationship, you could use LOOKUPVALUE.

Regards,
Pat

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks. RELATED worked fine for me since there is a relationship between tables.