Forum Discussion
Anonymous
7 years agoNot applicable
Calculating difference between consecutive rows
hello i am new to power bi , and i have some struggle with this. my data look like this (small portion:) DATE / sum 2018-07-01 / 200 2017-09-03 / 400 2016-19-04 / 500 i want to calcu...
- Anonymous7 years ago
Hi all,
i manged to solve this using this answer:
basicly i had to calculate for each date the previous date (under the current filters) and then return the result for that date
v-jiascu-msft
7 years agoMicrosoft Employee
Hi Anonymous,
Please provide a sample of the original data. Since the dates aren't in order by dates, how can we determine which one is former, which one is latter?
Best Regards,
Dale
- Anonymous7 years agoNot applicable
Hi all,
i manged to solve this using this answer:
basicly i had to calculate for each date the previous date (under the current filters) and then return the result for that date
- v-jiascu-msft7 years agoMicrosoft Employee
Thanks for sharing, Anonymous.
Best Regards,
Dale