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
9 Replies
Hello KatjaPosohin
Can you try below DAX code..Revenue = Sumx('Sales','Sales'[Units] * 'Sales'[Price] )Let me know if it is working or not.
Regards
sanaltyics
Hi,
That calculated column formula seems correct. Share the download link of the PBI file.
HI 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.
-
Hi KatjaPosohin ,
Just checking in to see if you query is resolved and if any responses were helpful. If so, kindly consider marking the helpful reply as 'Accepted Solution' to help others with similar queries.
Otherwise, feel free to reach out for further assistance.
Thank you.
Hi KatjaPosohin ,
Following up to see if your query has been resolved. If any of the responses helped, please consider marking the relevant reply as the 'Accepted Solution' to assist others with similar questions.
If you're still facing issues, feel free to reach out.
Thank you.
Hi KatjaPosohin ,
We’re following up once more regarding your query. If it has been resolved, please mark the helpful reply as the Accepted Solution to assist others facing similar challenges.
If you still need assistance, please let us know.
Thank you.
