Forum Discussion
Comparing not sequencial days
Hello!
I need to compare a result of a project that changes almost every day. However, we can have some day with no changes and therefore with same result as previous day. But the source system gives me the figures as below, just showing the days that had variances. So I need to have a measure as column Var below.
Can you please help me?
Thanks!
| Date | Result | Var |
| 01/01/2019 | $ 150,052 | $ 0 |
| 02/01/2019 | $ 148,041 | $ -2,011 |
| 04/01/2019 | $ 151,052 | $ 3,011 |
| 06/01/2019 | $ 150,850 | $ -202 |
Anonymous
You may check if the following post helps.
3 Replies
Sorry i don't quite understand. Please can you paste a screenshot from excel of the output table you would like? Also if you could upload your pbix file to https://uploadfiles.io/ that would make life easier :-)
Thanks,
CM
Hi CM.
Sorry for late replied. I tried by myself but no success.
I have uploaded the pbix file in the link below. As you can see, I want to compare the Difference per day and per week. And then, show the accounts for this variance: if was related to cost or revenue.
I really appreciate your help.
Thanks!
Anonymous
You may check if the following post helps.