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 headerspends
Salary23000
marketing2500
team outing 300
team dinner2500
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 👍

2 Replies

  • DOLEARY85's avatar
    DOLEARY85
    Resident 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.