Hi there,
Im looking for help to write the correct measure to pick the price based on the latest date and time.
A simplified version of my data set looks like this :
<tbody>
</tbody>
Im looking for the outcome where i write a measure, and it picks the latest observation, and in this case display the price 15,50 from the newest observation made 21.05.2019 at 10:20
Im looking for help to write the correct measure to pick the price based on the latest date and time.
A simplified version of my data set looks like this :
ID | Price | Time |
21 | 15,2 | 21.05.2019 10:00 |
21 | 15,9 | 21.05.2019 10:10 |
21 | 15,5 | 21.05.2019 10:20 |
21 | 14,7 | 20.05.2019 19:00 |
21 | 14,9 | 20.05.2019 19:30 |
<tbody>
</tbody>
Im looking for the outcome where i write a measure, and it picks the latest observation, and in this case display the price 15,50 from the newest observation made 21.05.2019 at 10:20