Solved: Re: Comparing not sequencial days

Anonymous · ‎07-12-2019

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 · ‎07-18-2019

@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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎07-18-2019

@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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

CloudMonkey · ‎07-12-2019

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 · ‎07-16-2019

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!