Forum Discussion

MuhamadIlhamsya's avatar
MuhamadIlhamsya
Frequent Visitor
3 years ago
Solved

Calculate for specific variables/material

I'm Trying to make calculation like IF equation in excel. 

The expectation is like when the material number is 1003067 i want it to be times 0.5 and the other materials would just times 1 (as original as it was)

Can you please help to suggest on how to do that?

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi MuhamadIlhamsya ,

     

    I suggest you to create a calculated column as below.

    Column = 
IF('Table'[MaterialNumber] = 1003067,'Table'[Total QTY] * 0.5,'Table'[Total QTY])

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi MuhamadIlhamsya ,

     

    I suggest you to create a calculated column as below.

    Column = 
IF('Table'[MaterialNumber] = 1003067,'Table'[Total QTY] * 0.5,'Table'[Total QTY])

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.