Forum Discussion
Dynamic measure for Overall return
Super UserHi Anonymous ,
Can you share the sample file please? If possible can you tell me how the overall calculation is made? if the excel file has the calculation then I can check the formula there.
It's a lot of data to punch in a power bi file. thank you.
Hi MFelix
Thanks for taking this up!
I will for sure share the sample file, but I do not seem to be able to do it here through the community.
Do you have an email which I can send it too instead?
Thanks 🙂
- MFelix
Hi Anonymous ,
Here in the community you need to send the files trough onedrive, googledrive, we transfer or similar type of links.
Don't forget if you are doing it trough Goggle or Onedrive don't put a password on it. If you prefer you can also send the link in private message using the same type of links.
Hi MFelix
Please find the google drive link here: https://drive.google.com/file/d/12OYIani5ZkmqjqeqnmrRAKirB1CM2RBT/view?usp=drivesdk
- MFelix
Hi Anonymous ,
Not really getting the selection of the values you have for product A the following dates:
3 years - 31/07/2020 - 31/08/2019
4 years - 31/07/2019 - 31/08/2018
5 years - 31/07/2018 - 30/04/2018
If you selection date is from April 2018 to April 2020 why are the values going from July to August?
If I do a manual selection of the data I can achieve your result imeditatly on the measure I created however I need to know how you select the context of the measure so I can give you the complete answer.
Can you explain a little bit better on how the selection of the data is made?