Formula works to create measure but not column

[juju]

I am looking to create a caculated column using the following formula ( based on two measures ) :

Cost = 
[MTD Cost]-[MTD Cost : PreviousDay]

This works when I create a measure, but doesnt work when I create a column - same formula. The error says a circular dependandcy was detected. Not sure how to avoid the circular dependancy.

[BhaveshPatel · Accepted solution]

Hi @juju

You can refer this BLOG for understanding how your formula works. 

[BhaveshPatel · Accepted solution]

Hi @juju

You can refer this BLOG for understanding how your formula works. 

[austinsense · Accepted solution]

short answer, include a column with a unique index in your table