Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |