Comparing not sequencial days

[Anonymous]

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

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may check if the following post helps.

https://community.powerbi.com/t5/Desktop/Percentange-Difference-on-selected-Years-only/m-p/589960#M279871

[CloudMonkey]

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

[Anonymous]

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.

DailyResult

I really appreciate your help.

Thanks!