Forum Discussion
First value based on slicer date
Dear Friends, I'm looking for a simple way to select a value based on the slicer date. In essence, I aim to determine the stock value associated with a particular date when I use the slicer to m...
Dear all and dear Greg_Deckler ,
Thanks for your feedback.
I'm trying to compare 2 stocks based on the time period. I want to see the % difference over time but the starting point must starts at 0.
I do a simple calculation: Stock value of the day / Stock value at the beginnnig of the period - 1.
Ex: Apple vs Nasdaq 100
The difficulty is to define the Stock value at the beginnnig of the period.
I hope I'm a bit clearer with the explaination.
Link of the file (no secret, only public information)
Thank you for your help.
Oncle Vini
@Greg_Deckler , Hi,
have you had the chance to look at my issue. Do you need more information to find out a solution?
Thank you
Oncle Vini