Forum Discussion

A_H's avatar
A_H
Frequent Visitor
7 years ago
Solved

add new column to table

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]),
)
)
Need Help
Show and Tell

2 Replies