Forum Discussion
Create Summarize table with DAX
Hi Devesh,
I created a sample pbix file(see attachment), please check whether that is what you want. First, Please create the relationship for Table1 and Table2 base on date fields...
Create relationship base on date fields
1. If you want to get a summarized table, you can create a calculated table with following DAX formula:
Output = SUMMARIZECOLUMNS ( 'Table1'[name], 'Table2'[category], 'Table1'[date], "amount", SUM ( 'Table1'[percentage] ) * SUM ( 'Table2'[amount] ) )2. If you just want to display as a table visual, you can simply create a measure as below.
NAmount = SUM('Table1'[percentage])*SUM('Table2'[amount])Best Regards
In the data you give everything has the same date.
In your real data are the two table related on date column?
Yes, they are related on date column. As we add data for next month, it should be filtered by date column.
Hi Devesh,
I created a sample pbix file(see attachment), please check whether that is what you want. First, Please create the relationship for Table1 and Table2 base on date fields...
Create relationship base on date fields
1. If you want to get a summarized table, you can create a calculated table with following DAX formula:
Output = SUMMARIZECOLUMNS ( 'Table1'[name], 'Table2'[category], 'Table1'[date], "amount", SUM ( 'Table1'[percentage] ) * SUM ( 'Table2'[amount] ) )2. If you just want to display as a table visual, you can simply create a measure as below.
NAmount = SUM('Table1'[percentage])*SUM('Table2'[amount])Best Regards
