Forum Discussion

credencial's avatar
credencial
Frequent Visitor
4 years ago
Solved

Creating a new table using DAX

Hello folks,

 

I need help. I have three tables (A,B,C), the first one is the base and the NEW TABLE must have values contained in TABLE B and TABLE C. Like this:

 

 

 

Can somebody help me?

  • amitchandak's avatar
    amitchandak
    4 years ago

    credencial , Check if this can help

     

    Union(summarize(TableB, [COD], [Date], "Value", Sum(TableB[Price])) , summarize(TableC, TableC[COD], TableC[Date], "Value", Sum(TableC[Price])) )

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    credencial , Check if this can help

     

    Union(summarize(TableB, [COD], [Date], "Value", Sum(TableB[Price])) , summarize(TableC, TableC[COD], TableC[Date], "Value", Sum(TableC[Price])) )

    • credencial's avatar
      credencial
      Frequent Visitor
      4 years ago

      Thank so much. I used summarizecolumns with FILTER to create new table with only cod values contained in the table A. 🙂