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 ...
  • 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])) )

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. 🙂