Calculate column in one table based off of 3 criteria in another table

[DataUser]

I have two Data tables - Table A and Table B. I want to calculate a column in Table A.

Q1: How do I set up the "Manage Relationships"?

Q2: What is the formula for the column called "Total" in order to achieve the below? When the Date in Table A is between or equal to the Start & End dates in Table, AND the Status is Active (not Archive), I want a sum for that date of the total amount

[amitchandak · Accepted solution]

@DataUser , You can create a new column like

sumx(filter(table2, table1[Date] >= table2[start Date] && table[Date] <=table2[end date] && Table2[Status] = "Active"),Table[Amount])

I have discussed various way in this video : https://www.youtube.com/watch?v=czNHt7UXIe8