Forum Discussion
Solved
How to select values from a database based on dates
I have a database where each record stores the value of a project. Anytime the value of the project changes, a new record is created with a date/time stamp so that all history of changes is stored i...
Would something like this work?
Would something like this work?
I think that works, thanks for the quick response. One more question. I actually have one more variable on my projects table on whether the project update is approved or not. I would like to exclude project updates that are not approved. For example if my data included approval and I selected today as a date, it would not use the Jun 22 update for Project A since it was not approved. Can I add a condition of Approved = "Y" into the measure you created
| Project Name | Value | Last change | Approved |
| Project A | 1000 | 1-Mar-22 | Y |
| Project A | 1500 | 1-Jun-22 | N |
| Project B | 500 | 1-Jan-22 | Y |