Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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
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
User | Count |
---|---|
119 | |
65 | |
65 | |
56 | |
50 |
User | Count |
---|---|
177 | |
84 | |
70 | |
64 | |
54 |