Forum Discussion
Change in shares
Resident RockstarHi, DEA
if you include a (scrubbed) sample of you data, it will be easier to help you.
What you can do to solve your case, is to create a stand alone table with the actual periods you want available. In the .pbix-file in the link, I created Last 7 days and Last 14 days. The calculation is performed depending on which of these are selected, based on todays date. This works as long as you have data for every day. If you have gaps in your data, the solution would have to be more complex.
Not sure how to attach the data ... i pasted sample data below
I want the user to select a date range (for example 08/26/2019 to 08/27/2019)
and the user would receive the list of IDs for which the # of shares changed (for example, with the sample data below, the user would see a table:
thanks for your help.
ID Change in Shares
1 30000000
Date class ID shares price ai weight Duration MV
2019-08-27 bench1 1 190073581 94 0.08 0.10 21.3 178,821,225
2019-08-27 bench1 2 168394639 91 1.89 0.09 16.7 156,421,780
2019-08-26 bench1 1 220073581 94 0.08 0.12 11.2 207,045,225
2019-08-26 bench1 2 168394639 91 1.89 0.09 13.7 156,421,780
