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

It looks like you're trying to create a new column for Revenue using the formula

Revenue = sales[Units] * sales[Price],

but it's not working as expected after pressing Enter. One likely issue is that you're trying to reference the columns using the sales table prefix while already working within that same table context.

In Power BI's data view (as shown in your screenshot), when you're creating a new calculated column directly within the same table, you should reference the columns without the table name prefix. So instead of sales

[Units] * sales[Price],

simply use Units * Price in your formula.

Also, ensure that both Units and Price are recognized as numeric data types—if either is stored as text, the calculation will fail silently. If you correct the formula and the data types are set correctly, the new Revenue column should generate as expected.

Passionate about leveraging data analytics to drive strategic decision-making and foster business growth.

Connect with me on LinkedIn: Rohit Kumar

[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