Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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.
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.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |