Forum Discussion

PascalT's avatar
PascalT
Helper I
8 years ago

Create a dynamic calculated Column from Different Tables

Hi, I know my title is a bit blurry...   So here is my issue: I've three tables: SumTable, Table2 and Table3 Table2 and Table3 contains one record each, and one of the columns if named Number. ...
Need Help
vik0810's avatar
vik0810
Resolver V
8 years ago

There is no such thing as "Dynamic DAX" like there is dynamic SQL. You dont need the column TableLink, you can achieve this with the SWITCH function

 

SWITCH(
    Table[TableNumber],  
    2, SUM(Table2[Number]), 
    3, SUM(Table3[Number])
    .........
)
PascalT's avatar
PascalT
Helper I
8 years ago

Hi and thank you very much. However, i dont have only Table2 and Table3, i've many more and the 2 or 3 are random ID...

Maybe i should add some screenshots...

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    Hi PascalT,

     

    Could you post your table structures with some sample/mock data, so that we can better assist on this issue? It's better to share a sample pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

     

    Regards