Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am having a hard time doing a calculated column that needs to, for each row, look for the next row that contains the same "ObjectKey" in the earliest timespan, and then do the current "Value of interest" - previous "Value of interest"
Example below:
In position [A] of the calculated column, we do Value of interest (1881598) - Value of interest (165108), because this is the next row with the same object key.
I've tried using the EARLIER function or simple variables with Calculate and filters, but it did not succeed.
Solved! Go to Solution.
Hi:
Can you check this out?
https://drive.google.com/file/d/1QIkzghShl21b3Dk4iamsPzYcwM3JR_42/view?usp=sharing
Thanks..
Hi, please find the dataset sample attached (I could not manage to attach the pbix file)
Hi:
Can you check this out?
https://drive.google.com/file/d/1QIkzghShl21b3Dk4iamsPzYcwM3JR_42/view?usp=sharing
Thanks..
Thanks! It worked
Hi:
Can you share the data? Thanks
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
24 | |
22 |