Compare values for two dates

[Anonymous]

Hello!

I have a single table with salesnumbers per customer per date:

ID|Date |Sales
1 |1.May|$100
2 |1.May|$120
3 |1.May|$0
1 |2.May|$110
2 |2.May|$90
3 |2.May|$20
1 |3.May|$80
.
..
...

Now, whats probably somehow special, is that those salesnumbers are not the value for a given single day but rather the total sum for the customer (i.e: customer number 1 had a total of $100 as per 1.May; but per 3. May his salesnumber decreased to a total sum of $80 - this customer canceled some orders). 

What I need to do in Power BI: the user needs to be able to select two dates in the report and a table needs to show the difference between those to dates.

So if the user chooses to compare the 1.May to the 2.May the result needs to show for customer 1:

Actual value: $110

Difference: +$10

Any help how to make this possible if very much appreciated!

[popov · Accepted solution]

Hi, @Anonymous

I prepared sample Power BI file. Hope it help you.

https://1drv.ms/u/s!AjofTPMqM9m3lpFSfZzIP3BhUFEL4w

[Anonymous]

Thanks so much! I‘ve been struggling a bit with adapting your solution to my model (which is a bit more complex then described) but I think its working now! (just a little sidenote if anyone else will be using this solution: I changed the formula for the measure Difference

Difference = [Actual value]- CALCULATE( SUM( Sales[SalesAmount] ); USERELATIONSHIP(Sales[Date]; 'Compare Calendar'[Date]); ALL('Calendar') )

Because what I wanted to know was the diff-value to the "Actual value". 
Thanks again!

[Anonymous]

Hi, I am facing a similar problem which includes the user to select 2 different dates on the slicers and the comparison should give a resut of increase or decrease of the sales between the selected dates. I tried to use the solution provided here, but I am unable to check the file. Could you help me resolve my issue. Thanks