Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |