Question
For each ID, How to show only the value of the latest date and the date before it.
For example for the data below, how to show 12/06 and 12/02 values for A and 12/05 and 12/03 values for B in the same table.
Date | ID | Value |
12/1/2020 | A | 2 |
12/1/2020 | B | 1 |
12/2/2020 | A | 3 |
12/3/2020 | B | 2 |
12/6/2020 | A | 5 |
12/5/2020 | B | 1 |