Fix DAX Column calculations?

[shantanu97]

I am new to power bi. Can anyone help me to fix these DAX column measure? I don't know why it is not working??? Attach .pbix file.

PBIX FILE

Data ModelDAX Column

@harshnathani @Anonymous @Fowmy 

[Anonymous]

Since you're creating a column in OLAP CUBE_Finance_WB (Can't you give your tables good names?), you cannot refer to other tables' columns just like that. You have to wrap them into RELATED/RELATEDTABLE. The highlighted part should be wrapped in RELATED.

[amitchandak]

@shantanu97 , I think you can not use measure in a column.

Can you share sample pbix after removing sensitive data.

[shantanu97]

@amitchandakhere is the file PBIX FILE

[amitchandak]

@shantanu97 , direct connection. Not opening. 

[simrantuli]

Try using 'RELATED' function.

[simrantuli]

Please find below the updated column measure.

Use 'RELATED'