add new column to table

[A_H]

Hi


I want to add a new coulmn for the below:

I am trying to calculate the sum of saleamount form OrderDetails table when concatinate filed in Target table = concatinate field in OrderDetails Table 

Actual Sales Achievment  =

CALCULATE (

SUM (ORDERDETAILS[Gross Total After Discount] ),

FILTER ( ORDERDETAILS,ORDERDETAILS[Concatenate]) = (Target,Target[CONCATENATE]),

)

)

[v-chuncz-msft · Accepted solution]

@A_H ,

You may refer to the following post.

https://community.powerbi.com/t5/Developer/Adding-custom-column-with-sum-of-sales-from-another-table...

[Greg_Deckler]

I believe you will need to use RELATED or RELATEDTABLE. Sample data would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490