Forum Discussion
Solved
Calculation between consecutive rows in dynamic table
Hi Power BI Community, I hope that you'll bring me solutions to the problem that I've been stucking with for a few days. I couldn't find a solution in similar subjects. I have a facts table that...
| Batch Number | Shrinkage L | Shrinkage W |
| CL65500 | -3 | 3.6. |
| CJ63520 | -3.2 | -3 |
| CH63500 | -2 | -5.6. |
| CK56200 | 3 | --2.6 |
| CT85600 | 5 | -5.9 |
| CJ65200 | -3.2 | -6.3 |
| FG56233 | --2.6 | -3.6 |
| GH53620 | --0.3 | -2.6 |
| VG45632 | 3 | -2.3. |
| GT89600 | -3.6 | --3.8 |
| CG59000 | -2.9. | -3 |
| BG65300 | -5 | 5 |
| VH45000 | -2.8. | 9 |
| it has two " - " mark | ||
| it has two " . " mark |
during enter data by oporotor, came this issue. this table had error two "-" and "." so how can remove from the table please give solution