Problem when calling column from differents table

[Anonymous]

Hello , 

Im working in Power BI  and i have column SS TO that i need from "SS Frcst CD" table when creating a new calculated column in "stck and sales KOKO" tables.

var SPR=
RELATED('clients masterdata'[target weekcover])*sales-stockini+ sales*'SS Frcst CD'[SS TO]

To be replenished =

var sales='stck and sales KOKO'[Sale Av cs]
var stockini='stck and sales KOKO'[Stck initial cs]
var SPR=
RELATED('clients masterdata'[target weekcover])*sales - stockini 

return
IF(SPR<=0;0;SPR)

Thanks, Best Regards

[v-yulgu-msft]

Hi @Anonymous,

Please share some sample data in above three tables and show us your desired out put (result values of the new calculated column [To be replenished]).

Regards,

Yuliana Gu