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]))

     

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Hey Anonymous ,

 

when they are connected you can get the value with a calculated column and the RELATED function.

This should work:

 

Sales = RELATED( Orders[Sales] )

 

 

Be aware that calculated columns are static. So the related value will be shown in the details table, but the value won't change if you do some slicing or change the context.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis