Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Adding a column from a related table

I have two tables with one-to-many relationship between them. One is an 'orders' table and the other is 'details' table. Orders table have unique OrderIDs while the Details table can have non-unique...
Need Help
  • FarhanAhmed's avatar
    FarhanAhmed
    4 years ago

    Create a calculated column like below in Order Table.

    _Total Sales = CALCULATE(SUM('Table (2)'[sales]))

     

FarhanAhmed's avatar
FarhanAhmed
Community Champion
4 years ago

Create a calculated column like below in Order Table.

_Total Sales = CALCULATE(SUM('Table (2)'[sales]))