Forum Discussion
How to calculate difference between data of two selected dates.
Dear Support Team, I really need your help to solve my requirement. Thank you so much in advance. I have searched everywhere but not able to solve it. My data source is as follows. Only one table, ...
Hi TomMartens ,
Thank you for sharing your idea. However, It didn't help me to achieve the complete solution that I was looking for but using your idea, I am able to solve it differently and implement something similar. Here is how I did it.
- Instead of using two date slicers, now I use only one slicer so I am able to catch the selected dates and use selected dates into a measure.
- In order to make sure, not more than two dates get selected, I wrote logic to throw an error when selected more than two dates because the main purpose of this report to compare two dates data and calculate the difference amount.
- Below are my Measure and reports (Output).
this really works. thanks!!