Forum Discussion
Solved
creating DAX table with multiple tables' summarize
Hi, I would like to create a summarize table that basically summarize info from two tables. For example : Table A Date Sale 1/1/2024 10 1/1/2024 20 2/1/2024 30 Table...
hello velvetine_123
please check if this accomodate your need.
Summarize =
SUMMARIZE(
'Date',
'Date'[Date],
"Sale Tbl A",
SUM('Table A'[Sale]),
"Cost Tbl B",
SUM('Table B'[Cost])
)Hope this will help you.
Thank you.
Jihwan_Kim
Super User
Super UserHi,
Please check the below picture and the attached pbix file.
It is for creating a new table.
SUMMARIZECOLUMNS function (DAX) - DAX | Microsoft Learn
expected result table =
SUMMARIZECOLUMNS (
'Date'[Date],
"Sales", SUM ( 'Table A'[Sale] ),
"Cost", SUM ( 'Table B'[Cost] )
)