Hi Kushal, intervalmatch is used when there are diferent date ranges to apply values, in this case all rows from table 2 has the same dates, maybe you only need a join to have all values from table 1 splitted into all values from table 2 (where Table1.Brand=Table2.SENDER)
Kushal, likely going to need QVW file on this one in order to get some further comments, as folks likely want to see your data model etc. as well in order to try to see exactly how you are doing things.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.