Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello
I am looking to compare Values between diffrent years
Year | Unique | Value |
1 | A | 5 |
1 | B | 10 |
2 | A | 15 |
3 | C | 16 |
2 | B | 20 |
so at the end im looking to have a subtraction from the highest year - the lowest year based on the Unique
Unique | Value |
A | 10 (15-5) |
B | 10 (20-10) |
C | 16 |
Would this be possible or would another method be needed
Solved! Go to Solution.
Hi,
try this:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
try this:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |