Calculate for specific variables/material

[MuhamadIlhamsya]

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?

[MuhamadIlhamsya]

hi @v-rzhou-msft 

Thanks a lot for the help! It works now.

Regards,

Ilhamsyah

[v-rzhou-msft · Accepted solution]

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.