Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Compare values for two dates

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!

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        Anonymous
        Not applicable
        5 years ago

        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