how to make selected column value 0

[Universe24]

Hello Experts,

I have below a sample table  I want to make 0 for "marketing".  

The table name is team details.

Row header	spends
Salary	23000
marketing	2500
team outing	300
team dinner	2500

[DOLEARY85 · Accepted solution]

Hi,

i'm unsure of the purpose of this but to just change the spends amount of the marketing team you could create a new calculated column in DAX with an if statement:

Column = if('team details'[Row header] = "marketing", 0, 'team details'[spends])

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Universe24]

Hi Doleary,

Thanks am able to get the output. Now next step is to insert some values into the marketing rows(i have nearly 200 rows in orginal table ), from another table called the marketing table. Please help me.