Create a new table using columns from other tables

Question

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 Answer

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

Forum Discussion

Create a new table using columns from other tables

1 Reply

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

Create columns group

Creating custom columns keeps returning a structured Table column