Forum Discussion
Difference from previous date value
Hi!
I need help with creating the following matrix:
| Previous Period value | Current period value | Difference | |
| Client1 | 100 | 50 | -50 |
| Client 2 | 200 | 200 |
from the following data:
| Date | Value | |
| Client1 | 18.03.2021 | 100 |
| Client1 | 21.03.2021 | 50 |
| Client2 | 18.03.2021 | 200 |
I have problems with creating measure/calculated column which calculates difference between periods
1 Reply
- amitchandak
Super User
Anonymous , with help from date table. Refer my blog
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9
