Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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.  ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

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