Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, im gonna show first an image just to help you undesrtand what im trying to do:
I want to calculate the difference between rows that have the same number in colum "Nºtrade" and the difference is between the row with "Cierre" - "Apertura".
I hope you undesrtand what im trying to achieve.
Its just a measure to cacluate the Profit&Loss of a list of trades.
@Caseiluva , I think offset can do a better job.
https://medium.com/microsoft-power-bi/power-bi-offset-function-84177cc2cafd
Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
7 |