Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Problem when calling column from differents table

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

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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