Calculated column

[Anonymous]

I want to fill 'Cumulative Ach Qty' column in 'Target Table' when 'Sales Table' is updated. Can anyone suggest me an expression for this?

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

In your scenario, you can create a calculated column like below:

Cumulative Ach Qty = SUMX(RELATEDTABLE('Sales Table'),'Sales Table'[Achieved Qty])

Best Regards,
Qiuyun Yu

[Anonymous]

Dear @v-qiuyu-msft,

It worked. Thank you very much Qiuyun Yu. 

[ankitpatira]

@Anonymous 

1. Create relationship between two tables using ProductID.

2. Then under Target Table create calculated column using below DAX,

Cumulative Ach Qty = RELATED(SUM(SalesTable[AchievedQty]))

[Anonymous]

@ankitpatira

I created a relationship using ProductID and tried your expression. But it gave the following error.

Please refer the below statement I found from web.

"The RELATED function requires that a relationship exists between the current table and
the table with related information. You specify the column that contains the data that
you want, and the function follows an existing many-to-one relationship to fetch the
value from the specified column in the related table."

Therefore, I can get the 'Target' value from 'Target Table' to 'Sales Table' using RELATED function. But, I want to fill 'Cumulative Ach Qty' column in 'Target Table' when 'Sales Table' is updated. Is there any suggestion please?