Forum Discussion
Dynamic slicer columns
Hi, I have a table I want calculate 3 new columns. Max = Story point * Low confidence multiplier Min = Story point * high confidence multiplier Medium = if (confidence = High th...
Hi Anonymous ,
I am not sure your problem, you could refer to my sample for details. If this is not waht you want, please correct me and inform me more detailed information.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Here you are. I tried both, none work, but good to know, columns won't work, already an important hint 🙂
| Work Item Id | Confidence | SP MD |
| 10 | High | 5 |
| 11 | High | 3 |
| 12 | Low | 110 |
| 13 | High | 3 |
| 14 | Medium | 5 |
| 15 | High | 3 |
| 16 | Low | 10 |
| 17 | Low | 5 |
| 18 | Medium | 5 |
| 19 | Medium | 5 |
| 20 | Low | 5 |
| 21 | High | 10 |
| 22 | Medium | 10 |
| 23 | High | 3 |
| 24 | Medium | 5 |
| 25 | Medium | 10 |
| 27 | Medium | 10 |
| 28 | High | 3 |
| 29 | Medium | 10 |
| 30 | High | 3 |
| 31 | High | 3 |
| 32 | Low | 10 |
| 34 | Medium | 10 |
| 35 | Medium | 5 |
Hi Anonymous ,
I am not sure your problem, you could refer to my sample for details. If this is not waht you want, please correct me and inform me more detailed information.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.