Create a new table using columns from other tables

[Anonymous]

So my main issue right now is with the CALCULATE function. In DAX I have:

CALCULATE(SUM('Price Table'[Price]), 'Price Table'[Title] in {"Product1"})

For my new table, this gives me the sum of all the prices with Title "Product1" How can I change it to wear it gives me the sum of all prices that have the same date as a row in my new table. I'm getting my new table date from another table that is related to my Price Table date. (m to m)

[Anonymous · Accepted solution]

So I didn't have my two outside tables "date" columns related to eachother, and that's why they weren't linking up properly