Could you please attach your sample data as twbx format.
Let's say that you name your date parameters, Date 1 and Date 2. You could then create calculated fields which pull the values only for those dates. You'll need one calculated field for each, as follows (Note: Close is the closing value of the stock in my data set):
IF [Date]=[Date 1] THEN
IF [Date]=[Date 2] THEN
Then you can just drag these onto your table.
See attached workbook. If this resolves your issue, then please be so kind as to mark it as the "correct answer." This will close the thread and will be helpful to others who may have a similar question in the future.
Stocks.twbx 4.6 KB
Great thanks! Is there a way to fix the formatting issue of all the rows appearing even if the value for those dates are blank?
I.e. Apple, Microsoft, Oracle, and Salesforce are all stocks that are bought at one point or another, but if Apple is not bought on 7/17 then all the rest will show the 7/17 value but Apple will be blank. I would like Apple to not be shown.
Is there a way to filter the table based on if one or both of the dates has a null or not?
I figured it out. You just make another calculated field with an if statement IF ISNULL(Calculation1) AND ISNULL(Calculation2)
Great. Glad you figured it out.