Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
new to this ...
I have a dataset with portfolio data at multiple dates.
My columns are dates, security ID and Shares.
I want a visual in which the user could select a time period (via a slicer with the date field in it) and gets the change in shares between the beginning and end date.
For example, if the user selects a time period of the past 7 days and the portfolio had 10 shares of xyz at the beginning of period and 50 shares of xyz at the end of period, i want the user to see a table that shows XYZ and 40 shares (50-10).
I am not sure how to organise my data to set this up in an efficient manner.
Hi, @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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
91 | |
86 | |
76 | |
66 |
User | Count |
---|---|
149 | |
117 | |
111 | |
106 | |
95 |