Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I would like to calculate the difference between rows that share the same prefix or "main" item name. Some of the items have a suffix (that represents the version of the item), and some don't. And for each case this needs to be taken into account to identify the same items, based on the same "main name". Here's an example. "Delta" column is the desired output:
Item: | Value: | Delta: |
EP37-V2 | 1 | |
EP37-V3 | 3 | 2 |
PR1141-1 | 2 | |
PR1141-2 | 6 | 4 |
PR1141-3 | 3 | -3 |
EP76-A | 7 | |
EP76-B | 2 | -5 |
abc | 7 | |
abc | 8 | 1 |
Solved! Go to Solution.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.