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