Creating a new table using DAX

[credencial]

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 · Accepted solution]

@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]

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