Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
40 | |
27 | |
20 | |
14 | |
8 |
User | Count |
---|---|
76 | |
48 | |
46 | |
20 | |
16 |