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 . .. ... ...
Need Help
  • 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