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.
I have a table with persons and amount paid pr month
I would like calculate the change of amount to previous amount for each record
Table:
Person | Month YY-MM | Amount | Calculation |
123 | 2021-05 | 50 | 0 |
123 | 2021-06 | 100 | 50 |
123 | 2021-07 | 100 | 0 |
123 | 2021-08 | 75 | -25 |
345 | 2021-05 | 100 | 0 |
345 | 2021-06 | 75 | -25 |
345 | 2021-07 | 75 | 0 |
345 | 2021-08 | 50 | -25 |
Looking forward for your inputs.
Thanks wdx223_Daniel and Jihwan_Kim,
both solutions works fine, I'm still in the development of my Dashboard, so I'm not able to measure performance on actual data, with several thousands of lines.
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
10 | |
6 |