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.
Irwan
Super User
Super Userhello 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.
thank you so much this is what i'm looking for !
- Irwan