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

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community 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