Forum Discussion
Creating new column for Revenue doesn't work
Hello, I'm trying to create a new column in the table section to calculate the revenue using the new column and the formula Revenue = sales[Units] * sales[Price] but it doesn't follow my co...
rohit1991
Super User
Super UserHI KatjaPosohin.
Can you try below steps please.
-
In a calculated column inside the same table, you only need to use [price] * [units] no table prefix required.
-
Make sure both [price] and [units] are numeric types, not text. Even if they look like numbers, Power BI might treat them as text.
Once both parts are correct, the formula should work perfectly.