Forum Discussion
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 . .. ... ...
Hi, Anonymous
I prepared sample Power BI file. Hope it help you.
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!
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