Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 B
Date | Cost |
1/1/2024 | 5 |
1/1/2024 | 10 |
2/1/2024 | 15 |
Date table
1/1/2024 |
2/1/2024 |
3/1/2024 |
4/1/2024 |
so obviously table A and table B are not directly connected but are connected to the same Date table. I'm looking to create a summarize table as below :
Summarized table :
Date ( from date table ) | Sale (from table A) | Cost (from table B) |
1/1/2024 | 30 | 15 |
2/1/2024 | 30 | 15 |
Solved! Go to Solution.
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.
Hi,
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] )
)
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.
thank you so much this is what i'm looking for !
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |