Creating calculated column that references itself (or workarounds to it)

[Anonymous]

Hi, quite new to Power BI and still have that excel mentality. Am trying to create a calculated column "CB", is there any workaround available that can get values just like column CB? Kind thanks.

[v-jingzhang · Accepted solution]

Hi @Anonymous 

In Power BI, it is not able to refer to itself when creating a calculated column. We need to convert it to calculating some kind of cumulative sum instead if possible. 

You can create other three columns with below code. However, I cannot figure out how to calculate CB with DAX. 

Amount(USD) = 'Table'[Price]*'Table'[Units]

Buy/Sell = IF('Table'[Units]>0,"Buy","Sell")

Running today = SUMX(FILTER('Table','Table'[DealingDate]<=EARLIER('Table'[DealingDate])),'Table'[Units])

Best Regards,
Community Support Team _ Jing