Forum Discussion

Universe24's avatar
Universe24
Frequent Visitor
3 years ago
Solved

how to make selected column value 0

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...
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    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 👍
DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

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's avatar
Universe24
Frequent Visitor
3 years ago

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.