Creating new column for Revenue doesn't work

[KatjaPosohin]

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 command after clicking enter. What seems to be the issue?

[v-veshwara-msft]

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.

[meechielvp60]

NextGen Data Aspirants Community - @dimitrissawyer@cyberdigits.onmicrosoft.com 

[v-veshwara-msft]

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.

[v-veshwara-msft]

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.

[meechielvp60]

@DS_BIConnector, @PwrBIConnector @sg_compass @flow @enterprised1 

[meechielvp60]

@jira , 

[rohit1991]

HI @KatjaPosohin.

Can you try below steps please.

1. In a calculated column inside the same table, you only need to use [price] * [units] no table prefix required.

2. 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.

[Ashish_Mathur]

Hi,

That calculated column formula seems correct.  Share the download link of the PBI file.

[sanalytics]

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